Combining multiple selects into 1 select.

[Andy]

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 = 'Y'
I would like to combine the 3 queries into 1 result for easy 
parsing/manipulation in my program.  Also, each of the queries may/will 
have duplicate IDs/Records....A record that appears in Query 1 will also 
appear in Query 2.

We are running version 3.23.54, for sun-solaris2.8 (sparc)
Thanks for any help!
-Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]