> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--MS_Mac_OE_3116138332_5044726_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Ruslan I build it also as:
SELECT * FROM DISTINCT tenders, pccodes WHERE (pcnd = nd) AND (((cy = 'IT')
AND (pd = 20020927)) AND (( tx_lw = 'illuminazione') OR (( pccodes.pccode >=
25244000 AND pccodes.pccode < 27000000 ))))
and describe in the last mail sent to the list but the result is always the
same
Parsing ignores that I ask BEFORE the conditions: country Italy and date yyy
Satisfied these conditions then it should retrieve all records where the
text contains "illuminazione" OR code of tender is between 25244000-27000000
It retrieves me French tenders ... with the statement at the top of the
mail. And those tenders have the word "illuminazione" in tx AND code of
tender between 25244000-27000000!
Have I to add more parenthesis?
luca
> Da: Ruslan Zasukhin <sunshine at public DOT kherson.ua>
> Risposta: valentina@lists.macserve.net (Subscribers of Valentina)
> Data: Sun, 29 Sep 2002 10:30:18 +0300
> A: valentina at lists DOT macserve.net (Subscribers of Valentina)
> Oggetto: Re: suppose ... (SQL syntax) 4!!
>
> on 9/29/02 3:35 AM, Luca Porfiri at liste@mail.sting.it wrote:
>
>> I wish to correct about the result ... this:
>>
>> SELECT * FROM DISTINCT table1, table2 WHERE
>> table1.A = xxx AND table1.B = yyy AND (table1.C = zzz OR table2.D = kkk) AND
>> table1.F = table2.F
>>
>> gives me occurrence as I wrote:
>>
>> SELECT * FROM DISTINCT table1, table2 WHERE
>> table1.C = zzz AND table2.D = kkk AND table1.F = table2.F
>>
>> I cannot understand ...
>
> This was told many times on list.
> You need use () intensively
>
> --
> Best regards,
> Ruslan Zasukhin [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft DOT com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list
> send a letter to valentina-on@lists.macserve.net
> -------------------------------------------------------------
>
> -MS_Mac_OE_3116138332_5044726_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: suppose ... (SQL syntax) 4!!</TITLE>
</HEAD>
<BODY>
Ruslan I build it also as:<BR>
<BR>
SELECT * FROM DISTINCT tenders, pccodes WHERE (pcnd =3D nd) AND (((cy =3D 'IT')=
AND (pd =3D 20020927)) AND (( tx_lw =3D 'illuminazione') OR (( pccodes.pccode &=
gt;=3D 25244000 AND pccodes.pccode < 27000000 ))))<BR>
<BR>
and describe in the last mail sent to the list but the result is always the=
same<BR>
Parsing ignores that I ask BEFORE the conditions: country Italy and date yy=
y<BR>
<B>Satisfied</B> <B>these conditions </B>then it should retrieve all record=
s where the text contains "illuminazione" <B>OR</B> code of tender=
is between 25244000-27000000 <BR>
<BR>
It retrieves me French tenders ... with the statement at the top of the mai=
l. And those tenders have the word "illuminazione" in tx <B>AND</B=
> code of tender between 25244000-27000000!<BR>
<BR>
Have I to add more parenthesis?<BR>
<BR>
luca<BR>
<BR>
<BR>
<BR>
> Da: Ruslan Zasukhin <sunshine at public DOT kherson.ua><BR>
> Risposta: valentina@lists.macserve.net (Subscribers of Valentina)<BR>
> Data: Sun, 29 Sep 2002 10:30:18 +0300<BR>
> A: valentina at lists DOT macserve.net (Subscribers of Valentina)<BR>
> Oggetto: Re: suppose ... (SQL syntax) 4!!<BR>
> <BR>
> on 9/29/02 3:35 AM, Luca Porfiri at liste@mail.sting.it wrote:<BR>
> <BR>
>> I wish to correct about the result ... this:<BR>
>> <BR>
>> SELECT * FROM DISTINCT table1, table2 WHERE<BR>
>> table1.A =3D xxx AND table1.B =3D yyy AND (table1.C =3D zzz OR table2.D =
=3D kkk) AND<BR>
>> table1.F =3D table2.F<BR>
>> <BR>
>> gives me occurrence as I wrote:<BR>
>> <BR>
>> SELECT * FROM DISTINCT table1, table2 WHERE<BR>
>> table1.C =3D zzz AND table2.D =3D kkk AND table1.F =3D table2.F<BR>
>> <BR>
>> I cannot understand ...<BR>
> <BR>
> This was told many times on list.<BR>
> You need use () intensively<BR>
> <BR>
> -- <BR>
> Best regards,<BR>
> Ruslan Zasukhin [ I feel the need...the =
need for speed ]<BR>
> -------------------------------------------------------------<BR>
> e-mail: ruslan at paradigmasoft DOT com<BR>
> web: http://www.paradigmasoft.com<BR>
> <BR>
> To subscribe to the Valentina mail list<BR>
> send a letter to valentina-on@lists.macserve.net<BR>
> -------------------------------------------------------------<BR>
> <BR>
> <BR>
--MS_Mac_OE_3116138332_5044726_MIME_Part--
--MS_Mac_OE_3116138332_5044726_MIME_Part
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
©2002 Luca Porfiri |
