International SQL-Ledger Network Association

This is an old revision of the document!

---

  SELECT invnumber, transdate, amount FROM ar WHERE customer_id NOT IN (SELECT id FROM customer)

  SELECT invnumber, transdate, amount FROM ap WHERE vendor_id NOT IN (SELECT id FROM vendor)