[mysql] polaczenie 4 tabel w jedna Opcje

[AndyPSV]

Na forum mysql (oficjalnym) powiedzieli mi, ze trzeba skorzystac z UNION ALL, jednak jak zrobic, aby to dzialalo?

Prosze o odpowiedz, dziekuje

[SQL] pobierz, plaintext 
SELECT amount,sell,buy,rate,date FROM `'.PRFX.'deals` WHERE loc = "'.substr(LG,1).'" ORDER BY date DESC LIMIT 20 
UNION ALL 
SELECT exchanged,sell,buy,rate,date FROM `'.PRFX.'deals` WHERE loc = "'.substr(LG,1).'" ORDER BY date DESC LIMIT 20 
UNION ALL 
SELECT nick,joined FROM `'.PRFX.'deals` WHERE loc = "'.substr(LG,1).'" ORDER BY date DESC LIMIT 20 
UNION ALL 
SELECT topic,date FROM `'.PRFX.'topics'.LG.'` ORDER BY date DESC LIMIT 20 
[SQL] pobierz, plaintext