Hi everybody,
I have just switched a cf site from using a MSAccess database to mySQL . The
following query produces and error now (did work in MSAccess):
SELECT t.transID, a.authorID, g.groupID, ts.transName
FROM (tbl_authors a INNER JOIN tbl_groups g
ON a.GroupID = g.groupID)
INNER JOIN
(tbl_transcripts t LEFT JOIN tbl_transcriptionists ts
ON t.TransID=ts.TransID)
ON a.AuthorID = t.AuthorID
WHERE t.status = 20
If I take out the LEFT JOIN statement and use this query instead, it works
just fine:
SELECT t.transID, a.authorID, g.groupID
FROM (tbl_authors a INNER JOIN tbl_groups g
ON a.GroupID = g.groupID)
INNER JOIN
tbl_transcripts t
ON a.AuthorID = t.AuthorID
WHERE t.status = 20
I am new to mySQL. Is there a limit to the number of nested joins in a
query? The error I get is:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
