SQL - Como hacer para que aparezcan las recetas en las que TODAS sus categorias esten en otra consulta?

select recete from recetas r , rlist rl, categoria c

Where r.rid=rl.rid and rl.cid=c.cid

and c.cid IN

(select cid from category

 where cname="Vegetarian" and cname="Diabetic");

select recete from recetas r , rlist rl, categoria c

Where r.rid=rl.rid and rl.cid=c.cid

and c.cid IN

(select cid from category

where cname="Vegetarian" and cname="Diabetic")

Function  totalCategorias (@rid int)

return int as

begin

return (select count(*) from rlist where rid = @rid)

end

select recetas.* from recetas

where totalcategorias(recetas.rid)  =  (select count(*) from categorias)