MySQL Forums
Forum List  »  Newbie

Inner Join Syntax
Posted by: nlee
Date: July 11, 2005 02:50PM

Hello:

I'm a newbie using ColdFusionMX7. What is the proper INNER JOIN syntax and what am I doing wrong in this example?

SELECT docID, docType, title, lastname, firstname, docYear
FROM ((faResearch INNER JOIN docTypeID ON faResearch.docTypeID = docType.docTypeID)
INNER JOIN joinerMain ON faResearch.docID = joinerMain.docID)
ORDER BY title

I have a db with scientists, publications and institutions. Several scientists can write one publication and I want to be able to find all the publications by scientist and their institutions. I guess I don't know the proper INNER JOIN syntax because I've tried everything. Any help will be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Inner Join Syntax
July 11, 2005 02:50PM
July 12, 2005 03:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.