a.ABLDNGD = b.ABLDNGD
cause your exist to be evaluated every time a.abldngd changes.
But EXISTS still only returns true or false...
This would work exactly the same
exists
(select 1 from MISCCHG b
where a.ASHPNBR = b.ashpnbr and a.ABLDNGD = b.ABLDNGD
and
ashPNBR = 'BN460619' and ABLDNGD = '20120817')
Charles
On Thu, Dec 6, 2012 at 3:20 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
a.ABLDNGD = b.ABLDNGD
