Excluding results
From: <tplonis_at_gr.com>
Date: 1998/02/06
Message-ID: <886789746.650051588_at_dejanews.com>#1/1
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 UsenetReceived on Fri Feb 06 1998 - 00:00:00 CET