Posted by clifden on 10/22/05 01:19

With mysql 4.1, could this is possible:

SELECT *
FROM
(
(
SELECT *
FROM a
WHERE (id1=0)
)
UNION
(
SELECT *
FROM a
WHERE (id2>1)
)
)
WHERE (id3>10)
ORDER BY id4

UNION syntax in a FROM clause don't seems to work... but without views,
how can this possible?

Thank you

[Back to original message]