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.
Subject
Written By
Posted
Inner Join Syntax
July 11, 2005 02:50PM
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.