select f.FruitName
from groups g
   join fruits f on f.GroupName=g.GroupName and f.FruitName like g.dop

select 
  f.FruitName , 
  chek = 
     case
        when  f.FruitName like g.dop
         then 1
         else 0
     end
from  fruits f  
   inner join groups g on f.GroupName=g.GroupName 

select 
  f.FruitName , 
  chek = 
     case
        when  f.FruitName like g.dop
         then 1
         else 0
     end
from  fruits f  
   inner join groups g on f.GroupName=g.GroupName 

SELECT f.FruitName, chek=
 ISNULL
 (
  (
   SELECT TOP(1) 1
   FROM groups g
   WHERE g.GroupName=f.GroupName AND f.FruitName LIKE g.dop
  ),0
 )
FROM fruits f;