Not sure about Access but in SQL you have to specify the fact that it's an
outer join so instead of LEFT JOIN use LEFT OUTER JOIN.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 15:37
To: CF-Talk
Subject: MS Access JOIN Error
I'm getting the following error when trying to do a left join from an Access
database from CF. I really don't know what I'm doing. Any clues would be
appreciated
Error Diagnostic Information ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Join expression not
supported.
SQL =
"SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS
MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA
Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close,
"MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA
Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor
FROM "MPA log" LEFT JOIN "52 log"
ON 'MPA log.MPA #' = '52 log.MPA #'"
Data Source = "HRTRACKER" The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44
Thanks in Advance
> Doug Kronenberger
> OI National Training and Education Office
> Depatment of Veterans Affairs
>
> 440-526-3030 x7776
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
