Hi CV, Sure it supports them, but I seem to recall it has its own SQL syntax. Best to use MSAccess' query builder, and then take a peek at the SQL that it creates. It should give you the idea. Let is know what you find, Lee Bjork Borkman Bjork.Net - ColdFusion Tags by Bjork ------------------------ "Cyrill Vatomsky" <[EMAIL PROTECTED]> wrote: Does MS Access support outer joins? I am trying to run this query on a MS Access 2000 file via CFQUERY: (Cust_Models has two columns: customer ID and Model ID. I want to retreive customers even if they do not have any models associated with them in the Cust_Models table.) ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
