select values from tables

Accepted answer

a is the name of table runtime you can put anything like temp, #temp or any other valid identifiers.

As in outer query you are using select , , ... from so after from you need to pass datasource that is table. Here table is runtime query so you need to give name for that.

+2

sathish7y ago

Thank you Suraj ..

+2

sathish7y ago

Thanks Suraj

And finally you given 'a' at the end .. Is that the syntax to be used with any character

+2

Suraj Kumar7y ago

You can try the below query.

create table table1 (col1 int)
insert into table1 values (200), (300), (500)
create table table2 (col1 int)
insert into table2 values (600), (800), (1000)
select min(Mincol1), max(Maxcol1) from
(
select min(col1) as MinCol1, max(col1) as MaxCol1 from table1
union all
select min(col1) as MinCol1, max(col1) as MaxCol1 from table2
)a

+1