Topic awaiting preservation: SQL problem2 (Page 1 of 1)

Hi, guys. How are you?
Can I ask you something?

sql = "SELECT Title, Colcategory, Price, state FROM Tblcategory INNER JOIN (Tbladd INNER JOIN Tblstate ON Tbladd.State = Tblstate.ID ) ON Tbladd.Category = Tblcategory.ID WHERE Tbladd.Title = 'Canon Canoscan 1540U' AND Tblstate.Colstate = 'Stockholm' "

I just trying to show the data using WHERE .....AND statement. There are three tables joined together.
Some reason, it doesnot show. Do you see any problem???
Cheers.

Hiroki Kozai

Hiroki: What database/langauge is this for? If it was MySQL then I'd think it'd be in that INNER JOIN - you might need to explain what you are doing.

___________________
Emps

The Emperor dot org

Hi,Emp. How are you?
Well, it is MS Access database and ASP.
There are tables. And I joined three of them to show the value of field.
I could do that.
But I wanted to know how to use multiple WHERE statement.
I thought I can say like

WHERE Tbladd.Title = 'Canon Canoscan 1540U' AND Tblstate.Colstate = 'Stockholm'

But When I put this sql after the one, which join three tables, didn't work.
Please help!

Hiroki Kozai