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




Return to Archive home page | Return to MIDRANGE.COM home page