Rick Faircloth wrote: > > I've just always found the joins, especially left, outer, inner, etc., to be > unintuitive when looking at the code. I guess I just haven't worked with > them enough. > I've always worked around them with subselects, which mySQL won't do. (Until > 4.2)
Some first form of subquery support was committed to CVS earlier this month, so that will be a while. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm