/* delete a record.
  You can tell if something was actually deleted by looking at the return code from executeUpdate. */
DELETE FROM contacts WHERE acct=2103;

/* conditional delete */
DELETE FROM suppliers
WHERE EXISTS
  (select *
    from orders
    where suppliers.supplier_id = orders.supplier_id);