What is the different between join statement and select for all entries?

Question

Accepted Answer

Join statement is used to combine data from multiple tables based on a common field, while select for all entries is used to retrieve data from multiple tables based on a list of entries.

Join statement is used when we want to fetch data from multiple tables based on a common field.
Select for all entries is used when we want to retrieve data from multiple tables based on a list of entries.
Join statement can be used with inner join, left outer join, right outer join, and full outer join.
Select for all entries is more efficient when dealing with large datasets.
Join statement requires a common field between the tables, while select for all entries requires a list of entries.

Accepted Answer

Joins are used to fetch the data from more than one table.

1. Inner join: This statement is used to extract the data from the multiples tables by

joining them. Up to 2 tables can only be joined. For more than 3 tables is

not advisable as it puts heavy load on database

2. For all entries: This statement is used to extract the data from the data base table

based on the entries of the Base internal table. The load on data base

will be very less.

What is the different between join statement and select for all entries?

Top BSC Global SAP Abap Consultant interview questions & answers

Popular interview questions of SAP Abap Consultant

Top HR questions asked in BSC Global SAP Abap Consultant