求救 ASP 中 sql 問題

HKSAR

SELECT AA.ID, da.ID
FROM (AA INNER JOIN BB ON AA.ID = BB.ID)
LEFT JOIN [select * from daily WHERE [Date]=#11/11/2008#]. AS da
ON AA.couseID = da.courseID;

在 ASP 上行上列SQL 會出 error
有冇 ching 識解決 ?

AA 係主資料表, BB 係副資料表, daily 係每日記錄

freewave

SELECT AA.ID, da.ID
FROM (AA INNER JOIN BB ON AA.ID = BB.ID)
LEFT JOIN (select * from daily WHERE [Date]='11/11/2008') AS da
ON AA.couseID = da.courseID

Try this!