--part1_76.2339030c.2ac7a4c3_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
This is just a stab, but does this help?
((table1.F = table2.F) AND (table1.A = xxx AND table1.B = yyy)) AND (table1.C
= zzz OR table1.D = kkk)
Why it may help- it resolves the relation first, and groups everything with
parentheses (Valentina likes clear grouping of conditions, although this will
change with new parser).
You could also spell it out in a long form (clearly not idea, but it could
cough the parser if nothing else does):
(table1.F = table2.F) AND ( ( (table1.A = xxx) AND (table1.B = yyy) AND
(table1.c = zzz) ) OR (table1.A = xxx) AND (table1.B = yyy) AND (table1.D =
kkk) ) )
HTH,
Brian
> table1.A = xxx AND table1.B = yyy AND (table1.C = zzz OR table1.D = kkk) AND
> table1.F = table2.F
>
--part1_76.2339030c.2ac7a4c3_boundary
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
<HTML><FONT FACE=arial,helvetica><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2" STYLE="BACKGROUND-COLOR: #FFFFFF">This is just a stab, but does this help?<BR>
<BR>
((table1.F = table2.F) AND (table1.A = xxx AND table1.B = yyy)) AND (table1.C = zzz OR table1.D = kkk)<BR>
<BR>
Why it may help- it resolves the relation first, and groups everything with parentheses (Valentina likes clear grouping of conditions, although this will change with new parser).<BR>
<BR>
You could also spell it out in a long form (clearly not idea, but it could cough the parser if nothing else does):<BR>
<BR>
(table1.F = table2.F) AND ( ( (table1.A = xxx) AND (table1.B = yyy) AND (table1.c = zzz) ) OR (table1.A = xxx) AND (table1.B = yyy) AND (table1.D = kkk) ) )<BR>
<BR>
HTH,<BR>
Brian<BR>
<BR>
<BLOCKQUOTE CITE STYLE="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px" TYPE="CITE"></FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2" STYLE="BACKGROUND-COLOR: #FFFFFF">table1.A = xxx AND table1.
B = yyy AND (table1.C = zzz OR table1.D = kkk) AND<BR>
table1.F = table2.F<BR>
</BLOCKQUOTE></FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2" STYLE="BACKGROUND-COLOR: #FFFFFF"><BR>
<BR>
</FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2" STYLE="BACKGROUND-COLOR: #FFFFFF"></FONT></HTML>
--part1_76.2339030c.2ac7a4c3_boundary--
--part1_76.2339030c.2ac7a4c3_boundary
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
©2002 Yennie .at. aol .DOT com |
