I wrote :
> =
> The SearchConditions must be grouped by table (within parenthesis if
> many conditions for a table) :
> =
> SELECT *
> FROM table_1, table_2
> WHERE table_2.field_1 =3D table_1.field_2
> AND
> table_2.field_2 =3D "y"
> AND
> (table_1.field_1 =3D "x" AND table_2.field_3 =3D "z")
Ooh, I made a mistake. You must read :
SELECT *
FROM table_1, table_2
WHERE table_2.field_1 =3D table_1.field_2
AND
table_2.field_2 =3D "y"
AND
(table_1.field_1 =3D "x" AND table_1.field_3 =3D "z")
^^^
Sorry.
Fran=E7ois Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique
©2002 Francois Van Lerberghe |
