Other way instead of for all entries.

I am fetching maintenance items from table MPOS and then using for all entries i am fetching WARPL from MPLA.

I can also use inner join instead of for all entries.

What can i handle this using new abap syntax rather than for all entries.

Select * from MPOS.

SElect * from MPLA for all entries in MPLA where warpl = mpla-warpl.