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:325660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
