Jeslek
Banned
OK someone bugged me with a very, very, very interesting question. What is the correct syntax to do a select query on a result set? For example... (I'm unsure of the first line)
Code:
select * from
(
select * from table1 where avalue1 in
(
select something from table3 where something2 = 1
)
union all
select * from table2 where avalue1 in
(
select something from table4 where something7 = 1
)
)
group by resultset.somevalue1
order by resultset.somevalue2;