Posted by --CELKO-- on 10/10/07 00:13

>> How can I now join these together in one list, with the results from the first query being listed before the second, i.e. keeping the same order. <<

I hope these are the real names of the data elements.

SELECT category, company, address1, address2
FROM Table1
WHERE category IN ('active', 'inactive')
ORDER BY category, company, address1, address2;

[Back to original message]