ALV Report: Get all columns from one table and few columns from other table

Hello,

I have developed an ALV Report in which,

1) I select data using select * from one table into internal table which is defined as TYPE STANDARD TABLE OF database table.

2) Build the field catalog using 'LVC_FIELDCATALOG_MERGE' and using the DB table as a structure.

3) Display grid using CALL METHOD g_grid->set_table_for_first_display.

Now there is some change in the requirement such that, I need to add few fields from other table into the layout. This new table is related to the existing table.

So please advice me,

1) How can I use inner join? Whether can I use select * from one table and select few fields from other table in inner join ?

Thanks and regards,

Anand