The answer turned out to be that I COULD use UNION, just with a couple twists I didn't know I could use. The final answer was this:
SELECT '1' as skey,'VEHICLE' as sname, owners.ownerid, owners.fname, owners.lname, owners.bname, vehicles.id, vehicles.ownerid, vehicles.year, vehicles.mfr, vehicles.model, '' as item_name,vehicles.price, vehicles.date_add FROM owners, vehicles WHERE vehicles.ownerID = owners.ownerID AND vehicles.date_add < #createODBCDate(variables.begin_date)# union all SELECT '2' as skey,'OTHER' as sname, owners.ownerid, owners.fname, owners.lname, owners.bname, other.id, other.ownerid, other.year, other.mfr , other.model , other.item_name,other.price, other.date_add FROM owners, other WHERE other.ownerID = owners.ownerID AND other.date_add < #createODBCDate(variables.begin_date)# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
