Help w/Joins PLZ
Posted: Thu Dec 19, 2002 4:24 am
TABLES
Author
id
first
mid
last
credid
Credential
id
name
art_authartid
authid
rank
QUERY
SELECT author.id, author.first, author.mid, author.last, credential.name,
FROM author, credential WHERE art_auth.artid=$artid AND art_auth.authid=author.id AND credential.id=author.credid ORDER BY art_auth.rank DESC
ERROR
MySQL said:
You have an error in your SQL syntax near 'FROM author, credential, art_auth WHERE art_auth.artid=2 AND art_auth.authid=aut' at line 1
PLEA
I'm slightly new to sql. Any help would be greatly appreciated.[/u]
Author
id
first
mid
last
credid
Credential
id
name
art_authartid
authid
rank
QUERY
SELECT author.id, author.first, author.mid, author.last, credential.name,
FROM author, credential WHERE art_auth.artid=$artid AND art_auth.authid=author.id AND credential.id=author.credid ORDER BY art_auth.rank DESC
ERROR
MySQL said:
You have an error in your SQL syntax near 'FROM author, credential, art_auth WHERE art_auth.artid=2 AND art_auth.authid=aut' at line 1
PLEA
I'm slightly new to sql. Any help would be greatly appreciated.[/u]