Article View: borland.public.vdbase.data.sql
Article #960Re: sql quirks
From: Jason Ortner
Date: Sat, 06 Jun 1998 00:00
Date: Sat, 06 Jun 1998 00:00
23 lines
1536 bytes
1536 bytes
>This may or may not be what you intended, but it should give you the >perspective to analyze the true relationships between your multiple >conditions and give you the means to arrange them to produce the result set >you intended. Do not for a minute think that this is now or always should >be a light task. It seldom is. And the more conditions with mixed OR and >AND operators you have, the greater the headache trying to arrange them >right. > Steve, Thanks a great deal for the time you took to explain the solution to the problem. I will use this knowledge in the future. I know about using the parens in math but it never hit me to apply them to the sql statements. I will go play with this and I am sure I will be able to get what I want now. Again thanks a bunch. Jason Ortner jortnerxxppmm@onramp113.org
Technical Details
Message-ID:
<6lceq4$1i28@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6l9obd$t6j4@forums.borland.com> <3582875d.32043883@forums.inprise.com> <6lam93$is1@forums.borland.com> <357daec9.6637195@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,7e01f50b41e45756 X-Google-Attributes: gidff5a1,public From: "Jason Ortner" <jortner@onramp113.org> Subject: Re: sql quirks Date: 1998/06/06 Message-ID: <6lceq4$1i28@forums.borland.com> X-Deja-AN: 360228808 Content-Transfer-Encoding: 7bit References: <6l9obd$t6j4@forums.borland.com> <3582875d.32043883@forums.inprise.com> <6lam93$is1@forums.borland.com> <357daec9.6637195@forums.inprise.com> Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql