Run multiple queries in Query

bhutan · 2020-05-25 12:02:46

Hello Admin,

Is it possible to run multiple queries in Query: under dynamic list.

Regards,
bhu.

eduardo · 2020-05-25 12:37:50

Hi bhutan,

you can run subqueries of course in the main query. Something like select * from (select * from mytable) a

Regards,
Eduardo

bhutan · 2020-05-25 14:37:49

Hello Eduardo,

I mean like:

select * from table1
select * from table2

Thanks,
Bhu.

eduardo · 2020-05-26 06:08:44

Hi bhutan,

a dynamic list shows you the result of one query. If both tables contain the same fields you can make a UNION query: https://www.w3schools.com/sql/sql_union.asp :

select * from table1
UNION
select * from table2

Regards,
Eduardo

ReportServer Forum