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

