Could do a UNION to gather the results -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:56 AM To: CF-Talk Subject: RE: Need query help
If you query is highly dynamic, this way may not be best. Let's say the user can specify groups that are of type college, jewish, preschool, catholic, and skinny. Now, you have to join to the type table 5 times and that ain't looking too good. ~Brad -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2008 6:27 PM To: CF-Talk Subject: Re: Need query help >No, that'll get one or the other - he wants ones that are both. > >Aliasing will work, something like this: James, I think I got this to work. My first tests are good. I didn't mention this is a highly dynamic query. I have quite a few other filters in play, but your example would work nicely with it. Thanks much! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
