SELECT ‘1st Query’ as whichone, col1, col2, col3 from table1
UNION
SELECT ‘2ND Query’ as whichone, col1, col2, col3 from table2
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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?