Hi all!

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
WHERE Table1.Field3=Table3.Field2

If remove WHERE query working properly:

SELECT Table1.Field1,
Table2.Field1,
FROM Table1
LEFT OUTER JOIN Table2
ON Table1.Field2=Table2.Field2

Any ideas?

TIA:
Sandor Szollosi