How do I write a query to achieve the following:
Posted: Tue Jun 15, 2004 5:48 am
I wish to extract everything from Web as a result of a username variable I have.
I have three tables:
User (username, password, bizname, etc etc)
Biz (bizname, bizstatus, add1, add2 etc etc)
Web (bizname etc, and other fields)
I have the Username variable (as a result of my login script, which should equal user.username) and wish to extract everything from Web where user.bizname=biz.bizname and then subsequently where biz.bizname=web.bizname.
Simon
I have three tables:
User (username, password, bizname, etc etc)
Biz (bizname, bizstatus, add1, add2 etc etc)
Web (bizname etc, and other fields)
I have the Username variable (as a result of my login script, which should equal user.username) and wish to extract everything from Web where user.bizname=biz.bizname and then subsequently where biz.bizname=web.bizname.
Simon