Try to run this query in "Query" tab in Access. If it works there - it must work in CF. If it would not work in CF - check version of ODBC drivers. Gennadi ----- Original Message ----- From: "Cyrill Vatomsky" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 13, 2000 4:09 PM Subject: OT:MS Access and outer join - not supported? > 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. > ------------------------------------------------------------------------------ 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.
