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 |