When there is already data in the internal table, use the For all entries in use, and other data should be obtained according to the data in the internal table already obtained.

Inner join and left join can check the description of SQL. Inner join is equivalent to multiplying several tables according to related fields. If the inner join table of ABAP is larger or more, its performance will decrease, so it is generally not recommended.