on 9/29/02 3:11 AM, Luca Porfiri at liste (AT) mail .D.OT sting.it wrote:
> In true I built ( a mistake by me in trascription in the last mail):
>
> 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
>
> and I confirm it doesn't work properly at all
> As I wrote it seems to always ignore
> table1.A = xxx AND table1.B = yyy AND (table1.C = zzz
> and consider only
> OR table2.D = kkk
Luca,
It seems I see where your problem.
Valentina DO NOT support query of type
WHERE tbl1.f = x OR tbl2.f2 = y
You need find run around for now, e.g. Do 2 queries.
--
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 |
