Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Union tables in query

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

This message was moderated.

apratsch
Explorer
0 Kudos

Hi Peter,

isn't it working like this?

Can you explain the problem?

Best regards,

Andreas

Former Member
0 Kudos

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!

Former Member
0 Kudos

You will have to use OUTER JOIN in this case...

0 Kudos

Dear Shah,

Could you explain me something more about UTER JOIN? Thank you !