Access数据库left join关联多表的查询

Question

set new = conn.execute (select a.*,b.productname,d.email from allproducts a left join myproducts b on a.productcode=b.productcode left join users c on a.username=c.username left join contacts d on c.CID=d.ID where a.productid='"&tPID&"' )

语句是这样的，在mssql2000下运行正常，在access数据库下提示 “下提示语法错误 (操作符丢失) ”

Access下具体要怎么改
Access下left join需要加（），已测试正确写法如下

set new = conn.execute (select a.*,b.productname,d.email from
(( allproducts a left join myproducts b on a.productcode=b.productcode)
left join users c on a.username=c.username)
left join contacts d on c.CID=d.ID where a.productid='"&tPID&"' )

Answer 1

access里，execute后的括号里应为字符串
set new = conn.execute ("select a.*,b.productname,d.email from allproducts a left join myproducts b on a.productcode=b.productcode left join users c on a.username=c.username left join contacts d on c.CID=d.ID where a.productid=" & tPID)