The query builder in access works real well and is pretty easy too. Load in all the tables in your query (I have found it best to load them in the access order l to r) and then add the columns. Of course for this to work, you have to record your relationships in the relationship tool. Works well though.
mark -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Monday, January 30, 2006 2:11 AM To: CF-Talk Subject: RE: join statements with MS Access 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:230727 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
