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 - 21:54:02 CEST