>>Is there a way around this?
Just create empty columns when they are missing, ie:
*SELECT*
first_name,
last_name,
off1_name,
off2_name,
off3_name,
atty_id,
email
FROM newstuff
UNION
SELECT
first_name,
last_name,
'' AS off1_name,
'' AS off2_name,
'' AS off3_name,
atty_id,
email
FROM oldstuff
ORDER BY last_name
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354109
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
