Posted by Steve on 09/17/07 22:08

"Alec" <ajtdds@aol.com> wrote in message
news:1190064167.203859.224910@19g2000hsx.googlegroups.com...
> Sorry newbie question...
>
> I have made two different search queries on the same table.
>
> How can I join these together in one list, so the results from the
> first query come listed before the second, ie keeping the same order.

no telling since you post no code. in keeping...

select *
from
(
select 'a' source
'2' field
from foo
union
select 'b' source
'1' field
from foo
) derived
order by source

[Back to original message]