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

• Next in forum: Re: REPOST: HELP! MySQL JOIN - Which one do i use?
• Prev in forum: Re: help with query
• Thread view: union in from clause

[Reply to this message]