or if you've to do it in one update useUPDATE aSET a.Frogs=CASE WHEN FrogsCnt > 0 THEN 'True' ELSE 'False' END,a.Dogs = CASE WHEN DogsCnt > 0 THEN 'True' ELSE 'False' END,a.Cats = CASE WHEN CatsCnt > 0 THEN 'True' ELSE 'False' ENDFROM AnimalsNamedJohnTable aCROSS JOIN (SELECT SUM(FrogsCnt) AS FrogsCnt,SUM(DogsCnt) AS DogsCnt,SUM(CatsCnt) AS CatsCntFROM(SELECT COUNT(*) AS FrogCnt,CAST(0 AS int) AS DogsCnt,CAST(0 AS int) AS CatsCnt FROM FrogsTable WHERE NamesColumn = 'john' UNION ALL SELECT 0,COUNT(*),0 FROM DogsTable WHERE NamesColumn = 'john' UNION ALL SELECT 0,0,COUNT(*) FROM CatsTable WHERE NamesColumn = 'john' )t)r
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/