MS Access 0 Select from multiple tables using Left Join in query

[Sudhakar]

I have the following query:

SELECT
T1.field, T2.field, T3.field
FROM
Table1 AS T1, Table2 AS T2
LEFT JOIN
Table3 AS T3
ON
T2.field=T3.field
WHERE
T1.field=T2.field

The query works in SQL Server 2000 but when I try to run it from MS
Access I get the following error dialog:

"Join expression not supported."

Can I not do in the MS Access or is this done differently.

Would appreciate any help.
Thanks
-sud