SELECT '1st Query' as whichone, col1, col2, col3 from table1 UNION
SELECT '2ND Query' as whichone, col1, col2, col3 from table2 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert James Sent: Thursday, May 17, 2007 12:11 PM To: pgsql-general@postgresql.org Subject: [GENERAL] UNION help Is there anyway to tell if the records in a union came from the 1st query or the second? Can I modify the individual queries to let me know this?