1. INSERT INTO verification (BranchID, SKU)
  2. SELECT
  3. stock.BranchID,
  4. stock.SKU
  5. FROM
  6. stock
  7. LEFT OUTER JOIN verification ON stock.BranchID = verification.BranchID AND stock.SKU = verification.SKU
  8. WHERE
  9. StockID IS NULL