M myTable
WHERE Closeout = 'Y'
HTH.. :)
Leo
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 02, 2004 1:34 AM
> To: [EMAIL PROTECTED]
> Subject: Combining multiple selects into 1 select.
>
> Hello,
>
> Is is possible to c
Hello,
Is is possible to combine the results of multiple selects into one
query/result? And if so, how do you implement it? A simple example follows:
Query 1:
SELECT *
FROM myTable
WHERE OnSale = 'Y'
Query 2:
SELECT *
FROM myTable
ORDER BY Category
Query 3:
SELECT *
FROM myTable
WHERE Closeout