On 21 Jun 2002 at 12:46, szsani wrote:

>I've got a problem with a query contains JOIN and WHERE.
>Table2.Field1 has same (wrong) value in all rows. (All the others is
>fine.)
>
>
>SELECT Table1.Field1,
>Table2.Field1,
>Table3.Field1
>FROM Table1,Table3
>LEFT OUTER JOIN Table2
>ON Table1.Field2=Table2.Field2

Huh! You have joined Table3 and Table2, but used Table1's field in
the join condition. I don't wonder that this doesn't work.
Try this:

FROM Table1 LEFT OUTER JOIN Table2
ON Table1.Field2=Table2.Field2, Table3
WHERE ...

or (if this doesn't work too)

FROM Table3, Table1 LEFT OUTER JOIN Table2 ON ...

>WHERE Table1.Field3=Table3.Field2

Another join condition? I'd say it is too much for the poor server.
As Helen said it would be better to put this join into FROM part too.

SY, Dimitry Sibiryakov.