Oracle SQL - Using joins to find values in one table, and not another

sql oracle

SubSELECTs are fine when used appropriately... "someone does not like something" alone is not a good enough reason IMHO.

There are several options - just 2 as examples:

SELECT nums.number FROM nums LEFT OUTER JOIN even ON even.number = nums.number WHERE even.number IS NULL

SELECT nums.number FROM numsMINUSSELECT even.number FROM even

sql oracle

for Oracle :

select nums.number  FROM nums,       even where nums.number = even.number(+)   and even.number is null;

for ansi SQL:

SELECT nums.number  FROM nums LEFT OUTER JOIN even ON nums.number = even.number WHERE even.number IS NULL;

CodeHunter