Try putting the Models table into the JOIN relationship - I've a sneaky
feeling that you can't select data from JOIN'd tables, then specify an
additional table which isn't involved in the join.
Sapphire Technologies Ltd.
Secure in the Knowledge
Simon Halcrow Web Developer
E [EMAIL PROTECTED]
T +44 (0)1642 702100
F +44 (0)1642 702119
W www.sapphire.net
> -----Original Message-----
> From: Gena [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 13, 2000 7:18 AM
> To: CF-Talk
> Subject: Re: OT:MS Access and outer join - not supported?
>
> 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.
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------
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.
