topic Re: Select data from multiple tables using only one select query in Application Development and Automation Discussions

Select data from multiple tables using only one select query

Former Member — Mon, 17 Dec 2018 07:00:33 GMT

Hi All,

I am making a report where the user chooses the names of tables he wants to select data from. I have to fetch data from these tables and upload the data as flat files to application server.

When writing the report, 2 things are unknown : name and number of tables. As the internal table also depends on the table, the structure will be unknown too.

Is there a way in which I can only write one select statement and it can be reused.

Something like:

Select * from [table name] into table [internal table name of same format].

where I can update the table name and internal table (which should be of the same format as the table) .

Thanks,

Samriddhi

Re: Select data from multiple tables using only one select query

DoanManhQuynh — Mon, 17 Dec 2018 08:44:30 GMT

Take a look at program: DEMO_DYNAMIC_SQL, you will know how to build a dynamic SQL.

Re: Select data from multiple tables using only one select query

s1252 — Mon, 17 Dec 2018 16:12:12 GMT

you can write something like this 

SELECT * FROM (p_table) INTO TABLE @DATA(lt_table) UP TO p_rows ROWS.

*lt_table will be dynamically created based on select output.