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.) <cfquery> SELECT C_ID, C_FirstName, C_LastName, M_ID, ModelName, ModelYear FROM (Customers left join Cust_Models ON customers.C_ID=Cust_Models.Cust_ID), Models WHERE C_ID=#form.C_ID# and Cust_models.CM_ID = Models.M_ID </cfquery> I get this: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (8:1) to (8:58). ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
