select join

[slighltywhacked]

Hi, im trying to get a SELECT join statement workin. How the tables are organized are listed below

table articles

|--aid--|--article_headline--|--article_body--|--article_date-------|
|---1---|---whatever-------|--fdsafdsaf-----|--456784561-----|

Table city_lookup
|--aid--|--cid--|
|---1---|--1---|
|--1----|--3---|

Table cities
|--cid--|--city----|
|--1----|-Kelowna-|
|--2----|-vernon--|
|--3----|-seattle--|

On one page I am givin the aid in the variable $aid. With this I have to find out everything about this article, as well as what cities it applies to.
So I came up with this:

$result= mysql_query("SELECT * FROM articles, cities WHERE aid = '$aid' AND articles.aid=city_lookup.aid AND city_lookup.cid=cities.cid") //get all info in articles table
or die("Error");

But its not working, Im getting the error part
Hope soneone can help

[oodie]

First off, you have to include table city_lookup in the query. Second, the clause "aid='$aid'" is ambiguous since you didn't mention the table name. Try thi:

SELECT * FROM articles, cities, city_lookup WHERE
articles.aid = '$aid' AND 
articles.aid = city_lookup.aid AND 
city_lookup.cid = cities.cid