INSERT Summary ( <fieldlist> )
SELECT <expressions>
FROM   <Server>.<Database>.<schema>.<table> ALIAS1
JOIN   <Server2>.<Database2>.<schema2>.<table2> ALIAS2
       ON ALIAS1.CommonKey = ALIAS2.CommonKey
WHERE  <expression>