Multi Material

Multi Material -

INSERT INTO pMaterialLinkComponent (
 ComponentTypeID ,(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)