>> ~lol~ yeah that's it.... Of course that makes the rest of us that didn't quite get it right dense too... ;o)
No, the difference is, you hadn't already spent half a day and night trying to figure out how to code the query! I had! :o) Rick -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:06 PM To: CF-Talk Subject: Re: How to do this without the subselect? > These two didn't work out, Stephen. > Never mind.... > Looks like Jochem's solution did it. > My first one should have been the same as Jochem's just wasn't paying attention and stuck the RW date checks in the wrong place... :o/ > I think the two solutions you suggested didn't work > because they both required that the > RentalWaiverDate's had to match the Form dates. > Because the only hits in the query would be those > that did have matching RentalWaiver dates, that caused nothing > to be returned even though there were 3 records that should > have been returned for the test date. > I had a feeling that nothing would be return from RentalWaiver table.... Sorry about that... > > 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. > Makes more sense when you match them up with Venn diagrams. > I've always worked around them with subselects, which mySQL won't do. (Until > 4.2) > All subqueries can be replaced with an appropriate JOIN, it just depends on how intuitive that query actually is.... Of course, when all else fails.... You could, ~shudder~, use query of queries........ > Or perhaps I'm too dense! :o) > ~lol~ yeah that's it.... Of course that makes the rest of us that didn't quite get it right dense too... ;o) > <cfset filter = valuelist(getWaivers1,clientID)> ^ you've got a comma here.... It should be a stop. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
