By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

case and count

P: 2
Could you please help me with this. I'm sorry, my English maybe is not good enough. I'm trying to make a right elect statement with count and case but I don't know the correct synthaxis. I'm working in an AS400, yes, I'm new. This enterprise makes things for cars. When the product is ready to export it's called finished product and the things that are necessary to make them are called components. So I have to get the quantity of pieces that form a finished product.
This information is in the same table. So there might several "component" for the same "finished product".
Please help me because it seems this might take too long and I don't have so much time to wait.
Jun 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.