International SQL-Ledger Network Association

  select ordnumber from oe where id in (select distinct trans_id from inventory where warehouse_id =0);