Recursive many to many query

select distinct ParentID from lego.contain where not parentid in (select childid from lego.contain);


select ParentID, childID, Qty ,
  parent.description as parent_desc,'<img src=' + parent.Image + '>' as p_picture,
  child.description as child_desc,'<img src=' + child.Image + '>' as c_picture
from lego.contain
  join lego.part parent on parentid=parent.partid
  join lego.part child on childid=child.partid
where parentid='7741-1';


select  PartID,Kind,Description,'<img src=' + Image + '>' as picture
from lego.part where partid in ('3680c02','3679','3680');