Complex MySQL query (tomhath lookie)!

gazoo

Hey,

I think I may be a bit too much of a MySQL newbie to understand your concept tomhath... Maybe you could elaborate on your explination a bit more?

<Quote>

The first table (Table1)
uniqueID,
sortorder,
listid

The second table (Table2)
uniqueID,
column1, column2, column3, ...

select a1.sortorder, b1.sortorder, c1.sortorder
from table1 a1, table1 b1, table1 c1, table2 t2
where a1.listid = $mylist
and a1.uniqueID = t2.column1
and b1.listid = $mylist
and b1.uniqueID = t2.column2
and c1.listid = $mylist
and c1.uniqueID = t2.column3
order by a1.sortorder, b1.sortorder, c1.sortorder

Source of the problem:

http://www.phpbuilder.com/forum/read.php3?num=5&id=30763&thread=30715

Gazoo...