Relationship between tables while using inner joins.

[Former Member]

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

[Sandeep_Panghal]

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.

[anjan_paul]

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

[Former Member]

 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

[Former Member]

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.

[Former Member]

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