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;

• Next in forum: bulk inserting uniqueidentifier column
• Prev in forum: Re: How to select a word substring in a coumn header from right to left
• Thread view: Re: Joining SQL Results

[Reply to this message]