Is there any difference in these two statements:

SELECT PLNITM, PLNSTR, PLNCDT as EFF_DATE,
PLNAMT, PLNADT,
FROM PFILE WHERE
WHERE PLNCDT > 150901 AND PLNITM = 2090312 AND PLNSTR < 11
OR PLNSTR = 0 AND PLNITM = 2090312
OR PLNSTR > 78 AND PLNITM = 2090312

SELECT PLNITM, PLNSTR, PLNCDT as EFF_DATE,
PLNAMT, PLNADT,
FROM PFILE WHERE
WHERE PLNCDT > 150901 AND PLNITM = 2090312 AND PLNSTR < 11
OR (PLNSTR = 0 AND PLNITM = 2090312)
OR (PLNSTR > 78 AND PLNITM = 2090312)

I have typically not used the parens with no apparent harm.

Thanks,

Dan Rasch

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].