Simple sql problem - I think!

[bluwe]

I want to select columns from three different tables where the customer_id column that exists on all three tables contains a certain value. I know you can go about it like this:

SELECT table1.column1, table2.column2 FROM table1, table2, table3
WHERE table1.column1 = table2.column1
AND table1.column1 = table3.column1;

But I already have the customer_id set as a variable and obviously I only want 1 row to be returned as the result of the query. Any ideas?


Thanks!!

[exploo]

just checking if i got the problem right.
You have a custumer_id, lets say its 233.
You want to select columns from three table where all the tables has costumer_id=233

SELECT table1.column1, table2.column2 FROM table1, table2, table3
  WHERE table1.column1 = table2.column1
  AND table1.column1 = table3.column1 AND table1.column=233;

[bluwe]

Can't seem to get that working - I didn't think you could have two AND statements in a select statement...

[bluwe]

My mistake - dodgy data - it works a treat! Thanks mate!!

[exploo]

Yeah, thougt so. You can have as many AND as you wish/need :)