UNION not allowed

[jeiman]

I have 3 tables where I want to search a result in both 3 tables. The problem is I just realize my MySql version 3, not allowed me to use UNION syntax. Is there any other way where I can get the result as same as UNION without using UNIon command??
Any help please..

[Lars_Berg]

The workaround is to use a temporary table. Populate the table with the separate queries you would like to union and then do a select distinct on the temp table.