result of 3 tablesusing IN()

[timmy01]

Hi!

I am having trouble to get some information
from table3 along with 2 other tables.

In total i am taling about tables 3...
this is the query i use:
<?
SELECT table1.var1, table2.var2
FROM table1, table2
WHERE table2.var2=table1.var2
AND table2.land='nl'
GROUP BY var1";
?>

With this i do get a list of results (var1)
the next step is to bring them back into
table3 and get the final results in a
good ORDER BY DESC.

so table 3 is still missing

My intentions is to put every result back into
table3, in the same query using IN()...

but i dont know how :-S

cheerz
Tim

[fenway]

Huh?