Excluding results

From: <tplonis_at_gr.com>
Date: 1998/02/06
Message-ID: <886789746.650051588_at_dejanews.com>#1/1


Is there anything Sybase that is equivilent to Oracles 'MINUS'(kind of the opposite of a union).

I want to being back results from one table if they are not in another table(I can't use a subselect because the unique primary key consists of 3 columns). Additionally, I cannot use an outer join because that table is already involved in an inner join of another table.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Fri Feb 06 1998 - 00:00:00 CET

Original text of this message