MySQL joining tables

[Anon]

I realise that MYSQL does not support the use of subqueries and the best workaround is to use a join. But for a search that I need on a few of my web sites pages I need information from 3 or four tables. My data structure is complicated but there is no way getting around this. Since I can not stick it all in a temporary table either (I am using 3.22) is this at all possible?

[Anon]

Just do a select as follows:

SELECT 1.column_name from table1 1, table2 2, table3 3, table4 4, where 4.id == 3.id

The numbers following the table names are references that can be used later. So if you want a column from table 4, you just put a "4." before the column you want to select. Hope this helps.