05-28-2013 4:03 AM
Dear Friends,
Could you give me some guidence about how to union tables in SQ02?
I put the table MSSL into "Alias tables", but no use here.
Now I want to make query to list the stock and value of packaging materials.
I use the table MARD as the basic stock table, MBEW to find the price and MVKE to ensure packaging materials.
But we want vendor stock also. Could you help to to add table MSSL into the list?
Thank you very much!
Best regards,
Peter
06-06-2013 4:47 AM
06-06-2013 10:36 AM
Hi Peter,
isn't it working like this?
Can you explain the problem?
Best regards,
Andreas
06-11-2013 3:38 AM
Hi Andreas,
What you list is join, not union.
Join used to select common items that both in 2 or more tables.
I want union to list all the items from both tables.
Thank you!
06-06-2013 11:15 AM
06-11-2013 4:17 AM
Dear Shah,
Could you explain me something more about UTER JOIN? Thank you !