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)