help in daynamic select

hi,

i wont to do one select instead of this both,

in every select i use 2 diff tables in from (table_selection)

one i have 2 use is dim_navatr001 and 2 dim0costcenter .

how i can do that?

Regards

SELECT (field_selection)

FROM (table_selection)

INTO TABLE <dy_actual>

FOR ALL ENTRIES IN l_tab

WHERE dim_navatr001 = l_tab-dim0costcenter

AND dim0calmonth IN g_m_a.

SELECT (field_selection)

FROM (table_selection)

INTO TABLE <dy_actual>

FOR ALL ENTRIES IN l_tab

WHERE dim0costcenter = l_tab-dim0costcenter

AND dim0calmonth IN g_m_a.

i can do that?

Regards