Merry Meet,
I have a query that pulls data from almost identical tables and I need to
know which rows come from which tables.
IE:
SELECT id, name
FROM table1, table2
WHERE table1.name LIKE '%#search#%'
OR table2.name LIKE '%#search#%'
then in the output I need to know which table (1 or 2) each record comes out
of. Can this be done? If so how?
Blessed Be,
--Katrina Chapman
http://www.katrinachapman.com
http://www.cfchick.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
