At 8:59 PM -0800 3/1/06, Boris Popov wrote:
I can't seem to get unions to sort properly,SELECT DISTINCT * FROM (SELECT t1.ID FROM GR_ADDRESS t1 UNION ALL SELECT t1.ID FROM PERSON t1) t1 ORDER BY t1.ID DESC results in "no such column: t1.ID" error. How would I go about sorting the result set in this case? Cheers! -Boris
Try removing the "t1." from both inner select statements, so it just says "select id" in both places. -- Darren Duncan