SELECT merch.id,
       IS_NULL(bill.id, 'NONE')
  FROM merchants merch,
       merchant_unpaid bill
 WHERE merch.id = bill.merch_id(+)
 ORDER BY 1,2