Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! Select Stmt
You might want to look at the "IN/NOT IN (SELECT subquery) options
SELECT a.vehicle_no
FROM table a WHERE a.vehicle_no NOT IN (SELECT b.vehicle_no FROM table b WHERE b.operation_date in (to_date(date1, 'mm/dd/yyyy'), to_date(date2, 'mm/dd/yyyy')));
Good luck Received on Thu Oct 11 2001 - 14:54:02 CDT