MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

Re: SQL help with EXISTS



fixed

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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact