If You are using OUTER JOINS: Access doesn't support outer joins on multiple tables. You can usually rewrite the query with Unions. My recomendation: use sql server in development too.
-----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: maandag 29 oktober 2001 17:04 To: CF-Talk Subject: OT: weird msg on sql to access change I have a development and production server. The only difference between them is the datasource- the production uses sql and the development has an access db. Well I have a query that works fine on the SQL server but conks out on the access one....I'm getting the message that the join expression not supported. Does this mean simply that the query is too complicated for ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
