Mark, You might be right but I never got that to work myself, in MSSQL.
An experiment you might try is to do that subquery separately in a different CFQUERY then plug in the retrieved value. Occasionally I have found that knid of trick is quicker. Kevin On Tue, Aug 25, 2009 at 11:49 AM, Mark Henderson <shadefro...@gmail.com>wrote: > > Kevin Roche wrote: > > > > Mark, > > > > What DBMS are you using? > > > > If its SQL Server, I don't think what you want to do is possible other > than > > how you have already done it. If you find another way to do it (with a > join) > > I would also be interested to see that. > > > > Kevin Roche > > > > Hi Kevin, > > Yes it's MS SQL. Are you sure I can't do a left join and use IS NULL > for the record that isn't allowed to match? > > If someone can tell me that the subquery is only run once then I'm not > too perturbed and will leave it as is. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4