topic Re: Relationship between tables while using inner joins. in Application Development and Automation Discussions

Relationship between tables while using inner joins.

Former Member — Mon, 27 Dec 2010 06:59:38 GMT

Hi,

I had a few clarifications on "inner joins", and as i was going through the forum, i came across two points,

1. In one of the threads it said " inner joins is applicable for tables that have a parent child relationship.

2. In another thread it said " inner join is established from master table (the table on the left) to the transcation table (the table on the right)".

I have two clarifications based on the above points.

1. Is it necessary that the tables on which im performing an inner join should have a parent-child/children relationship or is it enough that the tables just have a common field.

2. Also is it necessary that the master table should come first, (or can i use any child table from where i can fetch the records when there is a mater table in my report) as shown below.

Eg: select * <fields> from <master table> inner join <table> on <field> into <itab>.

Edited by: Narayananchandran on Dec 27, 2010 12:31 PM

Re: Relationship between tables while using inner joins.

Sandeep_Panghal — Mon, 27 Dec 2010 07:02:56 GMT

I have two clarifications based on the above points.
1. Is it necessary that the tables on which im performing an inner join should have a parent-child/children relationship or is it enough that the tables just have a common field.
2. Also is it necessary that the master table should come first, (or can i use any child table from where i can fetch the records when there is a mater table in my report) as shown below.

1.Common field is enough.

2. There is no such rule.

Re: Relationship between tables while using inner joins.

anjan_paul — Mon, 27 Dec 2010 08:27:56 GMT

Hi,

1. Is it necessary that the tables on which im performing an inner join should have a parent-child/children relationship or is it enough that the tables just have a common field.

2. Also is it necessary that the master table should come first, (or can i use any child table from where i can fetch the records when there is a mater table in my report) as shown below.

Eg: select * <fields> from <master table> inner join <table> on <field> into <itab>.

ans:

1 . You have to take every common fields not partial.

2. There is no such rule

Re: Relationship between tables while using inner joins.

Former Member — Mon, 27 Dec 2010 08:35:30 GMT

 have two clarifications based on the above points.
1. Is it necessary that the tables on which im performing an inner join should have a parent-child/children relationship or is it enough that the tables just have a common field.
2. Also is it necessary that the master table should come first, (or can i use any child table from where i can fetch the records when there is a mater table in my report) as shown below.
Eg: select * <fields> from <master table> inner join <table> on <field> into <itab>

1) NO 2) NO

Re: Relationship between tables while using inner joins.

Former Member — Mon, 27 Dec 2010 09:34:14 GMT

Hi,

1. It is not necessary that the tables on which im performing an inner join should have a parent-child relationship. There is no such rule.

2. Also it is not necessary that the master table should come first. Tables can come in any sequence.

Re: Relationship between tables while using inner joins.

Former Member — Mon, 27 Dec 2010 09:38:20 GMT

Hi,

Check the relation in SQVI transaction and check whether any join exists for the table you want to Join.

for your questions the SQVI transation will be the right Answer.

prabhudas