Do more with
insert into (col1,col2)
select this, that
from query1 q1
join relationship r
on r.clientid = q1.clientid
join query2 q2
on q2.locationid = r.locationid
INSERT INTO ProgramCustomer (ProgramID, CustomerID)
SELECT p.ProgramID, c.CustomerID
FROM Program p
INNER JOIN Customer c ON c.GroupCode = p.GroupCode
WHERE NOT EXISTS( SELECT NULL FROM ProgramCustomer pc WHERE pc.ProgramID = p.ProgramID and pc.CustomerID = c.CustomerID )
Premium Content
You need an Expert Office subscription to comment.Start Free Trial