Wednesday 10 June 2015

TSupplier axpayer ID query

SELECT id
  FROM (SELECT rownum + 100000000 id
          FROM dual
       CONNECT BY level < 1e9
       ) tax_ids
 WHERE NOT EXISTS ( SELECT NULL
                      FROM ap_suppliers
                     WHERE num_1099 = tax_ids.id
                  )

No comments:

Post a Comment