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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Table Join With SQVI

arjun_behera
Participant

‎2012 Jun 16 10:45 AM

0 Kudos
2,174

Hi All,

I am trying to use the query viewer to run a report where in I am trying to join more than 2 tables using t-code SQVI , however I have a small doubt does joining table using SQVI requires a common field accross all the tables that are been joined if not then how do we join more than 2 tables that does not have a common field across all the tables.

Regards,

AB

2 REPLIES 2

Clemenss
Active Contributor

‎2012 Jun 16 11:46 AM

0 Kudos
372

Hi Arjun Behera,

create quickview, select datasource table join. Add tables one after one to graphic. System will propose join conditions drawing lines. You can right-click the lines to delete join condition or change inner to outer join condition.

Play with it and try - that's what we all do.

Regards,

Clemens

ThomasZloch
Active Contributor

‎2012 Jun 16 3:49 PM

0 Kudos
372

You can join tables 1 and 2 via field A, and tables 2 and 3 via field B, so it need not be the same field A across all three tables.

Thomas