>Admittedly, I don't use Access that often, but that hasn't been my >experience. My experience has been that Access will treat non-ANSI joins as >described above as inner joins, at least with regard to passthrough SQL >statements from CF.
I just tried Matthew's query in Access and it worked just fine. So...my apologies, Matthew, for misleading you and thank you, Dave, for sharing the wisdom of your experience. :) ~Dina ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4