Patricia G. L. Hall wrote: > > Select > Case > ( > Select count(etp.etprocedureid) > from eTransferProtocolLink etp > Where etp.etProcedureid = et.etProcedureid and > etp.protocolid = 12 > ) > When 0 then 0 > When null then 0 > Else 1 > End as GIFT, > et.caseid > from etprocedure et > > Which produces these results: > > CaseID | GIFT > ------------------- > 76 0 > 77 1 > 78 0 > 78 1 > > I need to modify the query so that instead of seeing two rows with caseid > = 78, I see one row and a GIFT column = 1. Or: > > CaseID | GIFT > ------------------- > 76 0 > 77 1 > 78 1 > > I would rather not do a [cfoutput group = 'caseid'] to solve the problem. > For one thing, I've simplified the query here...
It would be easier if you showed the real query. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
