468,257 Members | 1,470 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

case and count

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
0 890

Post your reply

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

Similar topics

6 posts views Thread by Simon Gibson | last post: by
1 post views Thread by Mr. Bungle | last post: by
5 posts views Thread by Jeff S | last post: by
2 posts views Thread by Donald Smith | last post: by
9 posts views Thread by Eric S. | last post: by
7 posts views Thread by Jan Nielsen | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.