>>For example, if you use Access to create JOIN query you will not get JOIN syntax. Instead you will get what I usually refer to as the "Access" join syntax.
Although I agree that the Access query builder has its limit, it does support INNER, LEFT anf RIGHT joins. I have written my own "advanced query builder", part of my "ODBCMyAdmin" project. It supports JOIN, WHERE, ORDER BY, GROUP, HAVING, sub queries, UNION, etc. All with drag'n drop on tables and columns, 100% CF and Javascript code, CF 5, 6, 7, 8 compatible... I just need lots of time, which I don't have, to document it and package it :-( -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4