Jump to content


Photo

result of 3 tablesusing IN()


  • Please log in to reply
1 reply to this topic

#1 timmy01

timmy01
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 05 September 2006 - 10:18 AM

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


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 05 September 2006 - 01:00 PM

Huh?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users