Inner Join Vs For all Entries

[Former Member]

Hi Friends,

Can any one explain, when to use For all Entries and when to use Inner Join and what are the advantages of for all entries over inner join statement ?

<removed_by_moderator>

thanks and regards

Srini

Edited by: Julius Bussche on Sep 6, 2008 11:47 AM

[Former Member]

search forum dont ask basic questions

[Former Member]

Thanks for your reply

[Former Member]

if you want to help me, can you please give me the links...

[Former Member]

check this link

[former_member184657]

The answer still remains the same

Search the forum. This question has been answered hundreds of times. So if you search, you can get all the links yourself. If you help yourself, others will be willing to help you too.

pk

[Former Member]

Hi srini,

INNER JOIN :- It is exactly like intersection or logical AND operator. This inner join will fetch the data from the tables if the record is available in all the tables that you are joining. If it is not available in one of the tables, the data will not be fetched.

FOR ALL ENTRIES :- Joining of many tables decreases the performance of the program. In real time you will not be allowed to join more than 4 or 5 tables. FOR ALL ENTRIES is used as substitute for joins. When ever for all entries is used it is needed to declare separate internal tables for each data base table. After getting the data from each data base table into respective internal tables move the records into another internal table which is containing the fields from both the tables.

[Former Member]

Hi Srini,

try to search SDN, this has been asked several time,

also refer to the thread:

With luck,

Pritam.