Topic awaiting preservation: SQL problem2 (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12960" title="Pages that link to Topic awaiting preservation: SQL problem2 (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: SQL problem2 <span class="small">(Page 1 of 1)</span>\$

Hiroki Paranoid (IV) Inmate From: NZ Insane since: Dec 2002	posted 10-30-2003 04:31 Hi, guys. How are you? Can I ask you something? code: 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
Emperor Maniac (V) Mad Scientist with Finglongers From: Cell 53, East Wing Insane since: Jul 2001	posted 10-30-2003 04:37 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
Hiroki Paranoid (IV) Inmate From: NZ Insane since: Dec 2002	posted 10-30-2003 05:10 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 code: 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

Topic awaiting preservation: SQL problem2 (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12960" title="Pages that link to Topic awaiting preservation: SQL problem2 (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: SQL problem2 <span class="small">(Page 1 of 1)</span>\$

Hiroki
Paranoid (IV) Inmate

From: NZ
Insane since: Dec 2002

posted 10-30-2003 04:31

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

code:

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

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted 10-30-2003 04:37

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

Hiroki
Paranoid (IV) Inmate

From: NZ
Insane since: Dec 2002

posted 10-30-2003 05:10

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

code:

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