09-06-2008 7:50 AM
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
09-06-2008 7:51 AM
09-06-2008 7:53 AM
09-06-2008 7:53 AM
09-06-2008 7:56 AM
09-06-2008 7:56 AM
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
09-06-2008 8:07 AM
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.
09-06-2008 8:09 AM