без UNION в MySQL

1 отговора 62 прегледа
#1

без UNION в MySQL

Здрасти,
MySQL вьв версиите под 4.0.0 не поддьржат UNION SQL statement.
Как мога да направя това без UNION
(SELECT DISTINCT movie1
FROM movies)
UNION
(SELECT DISTINCT movie2
FROM movies)
UNION
(SELECT DISTINCT movie3
FROM movies)

Отговор
в отговор на Tsveti #2

outer joins

mojesh da emulirash UNION s temp tablica:

CREATE TEMPORARY xxx SELECT ...
INSERT xxx SELECT ...
SELECT xxx ...

Отговор