Multi Material

Multi Material -

INSERT INTO pMaterialLinkComponent (
 ComponentTypeID , ComponentSearchTypeID)
SELECT a.ComponentTypeID
 ,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)