I'm using this script to locate records in my SBA table where the product no longer exists..

Code:
SELECT * 
FROM   zen_products_with_attributes_stock
LEFT OUTER JOIN zen_products
  ON (zen_products.products_id = zen_products_with_attributes_stock.products_id)
  WHERE zen_products.products_id IS NULL
I have validated that these products no longer exist.. so I'm confident that these records can be deleted from the SBA table.. I need to know how to delete these records.. Kinda stumped on how to do this.. Hoping smarter brains than mine can help here..