[sqlite] ORDER BY of UNION?

[Boris Popov]

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

-- 
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5

[EMAIL PROTECTED]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that is
private and confidential. If you have received it in error, please
notify the sender and delete the entire message including any
attachments.

Thank you.

smime.p7s
Description: S/MIME cryptographic signature