Multi Material

Multi Material -

 
INSERT INTO pMaterialLinkComponent ( 
 ComponentTypeID , ComponentSearchTypeID) 
SELECT a.ComponentTypeID 
 , b.ComponentTypeID
 
FROM pComponentType a 
 , pComponentType b 
WHERE NOT EXISTS ( 
  SELECT 1 
  FROM pMaterialLinkComponent mlc 
  WHERE mlc.ComponentTypeID = a.ComponentTypeID 
   AND mlc.ComponentSearchTypeID = b.ComponentTypeID)