Jump to content

Archived

This topic is now archived and is closed to further replies.

timmy01

result of 3 tablesusing IN()

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.