What I have found with access, besides being a pain is to put all your tables names on the FROM line and do your joins on the WHERE line, then let access calculate the inner joins for you. To do that open access and create a new query (like a view in sql server), then right click to see the "sql view", paste your query, then close and save. Open the query again and go to "sql view" and you should see the proper inner joins with the parenthesis the way access likes them. Hope that helps.
Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ > -----Original Message----- > From: CF-Talk [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 29, 2006 10:06 PM > To: CF-Talk > Subject: CF-Talk: Digest every hour > Is there anyone on the list who can help me figure out where to put > the parenthesis for multiple join statements? This isn't working: > > SELECT * > FROM [ARTISTS] AS [P] > INNER JOIN ([ART] AS [A] > INNER JOIN [MEDIA] AS [M] > ON [M].[mediaid] = [A].[MEDIAID]) > ON [A].[artistid] = [P].[ARTID] > > These tables are from the cfcodeexplorer.mdb that's part of the CF > examples. > > Frustrates the hell out of me because they don't wrap the item they > belong to, instead they wrap part of the item they belong to and part > of the parent item... and they seem to change places between 0 and 3 > joints (after 3 they seem reasonably consistent)... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54