Beginner and Learner in SAP

[#1]

Hello , I want to know how can we not use "JOIN" to fetch the data table by table and how can we not use "FOR ALL ENTRIES" means what is the alternative way of using "FOR ALL ENTRIES". 

[aravindhan2529]

It depends on what you're trying to achieve. FOR ALL ENTRIES isn't something that needs to be avoided in every case—it still has valid use cases.

If your tables are related, I'd normally go with an INNER JOIN or LEFT OUTER JOIN, especially on SAP HANA, since they're usually more efficient and easier to read.

If a join isn't appropriate, you can also consider subqueries (EXISTS or IN), depending on the requirement.

The important thing is to choose the approach that fits your scenario rather than trying to replace FOR ALL ENTRIES in every case. Each option has its place.