main logo
Subject: Re: suppose ... (SQL syntax) 4!!
Author: Ruslan Zasukhin
Posted: 2002/09/29 02:30:18
 
View Entire Thread
New Search


on 9/29/02 3:35 AM, Luca Porfiri at liste At mail .D.OT 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@paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list
send a letter to valentina-on At lists .D.OT macserve.net
-------------------------------------------------------------
 
©2002 Ruslan Zasukhin
<-- Prior Message New Search Next Message -->