Quote:
<cfquery name="getarticles" dsn="mydsn">
SELECT a.articleid, a.articletitle, a.articleauthor, a.articlecontent, a.articlepdf, a.subjectid, s.subjectname
FROM tblarticles a
INNER JOIN tblsubjects s ON a.subjectid = s.subjectid
</cfquery>
But another person said to do it this way:
Quote:
<cfquery name="articles" datasource="mydsn">
SELECT subject.sID, subject.sName, article.aID, article.aTitle, article.aAuthor, article.aContent, article.aPDF, article.sID
FROM subject, article
WHERE subject.sID = #URL.variable#
AND subject.sID = article.sID
ORDER BY subject.sID ASC
</cfquery>
Does it really make a difference? Do they both do the same thing, and it is a matter of preference? Or is their some functionality innate in one that is not accessible using the other?