How to avoid appending matching records ?
From: Larry Cipriani <lvc_at_cbnews.cb.att.com>
Date: 16 Apr 92 01:17:59 GMT
Message-ID: <1992Apr16.011759.6548_at_cbnews.cb.att.com>
Date: 16 Apr 92 01:17:59 GMT
Message-ID: <1992Apr16.011759.6548_at_cbnews.cb.att.com>
I have two tables A and B which share a common schema.
In that schema I have 60 fields, f1, f2, ... f60.
Basically, I want to append A - B to A, but I want the
difference to operate only on two fields f1, and f2. From
what I can tell, 'MINUS' operates on entire records.
Or ...
Thanks,
-- Larry Cipriani, att!cbvox1!lvc or lvc_at_cbvox1.att.com "Be wary of strong drink. It can make you shoot at tax collectors - and miss." -- Lazarus LongReceived on Thu Apr 16 1992 - 03:17:59 CEST