Re: Excluding results

Try something like this.

	select a.column1, a.column2, a.column3
	from table_a a
	where not exists
	(select * from table_b b
	 where a.column1 = b.column1
	 and a.column2 = b.column2
	 and a.column3 = b.column3)

This would give you all rows in table table_a which are not duplicated in table_b for the given set of restrictions. Received on Fri Feb 06 1998 - 00:00:00 CET