Hi, There are two drivers for Access database in CF9 : - Microsoft Access - Microsoft Access with unicode
If I choose the first one, the query below works and yield the same results as when run in Access itself. However, If I use the driver with Unicode, the LEFT JOIN returns no data. The table succes is actually a view, not a table. I suspect the first driver is ODBC, the second is JDBC. There must be some problem in the JDBC driver. SELECT DISTINCT TOP 10 destinataires.courriel, succes.fichemessage FROM (messages INNER JOIN destinataires ON messages.ficheMessage = destinataires.ficheMessage) LEFT JOIN succes ON messages.ficheMessage = succes.fichemessage ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm