| Subject | SELECT UNION with ORDER BY?! |
|---|---|
| Author | matijamikac |
| Post date | 2005-04-11T15:09:32Z |
Isn't it possible to define SQL query similar to:
SELECT T1.*,T2.A WHERE T2.ID=T1.ID
UNION
SELECT T1.*,T1.B WHERE T1.ID=-1
ORDER BY 0 /or T1.C
(Union works well, but when trying ORDER BY I get invalid ORDER BY
clause error)
What am I doing wrong?
SELECT T1.*,T2.A WHERE T2.ID=T1.ID
UNION
SELECT T1.*,T1.B WHERE T1.ID=-1
ORDER BY 0 /or T1.C
(Union works well, but when trying ORDER BY I get invalid ORDER BY
clause error)
What am I doing wrong?