c# Access 2003数据库Join语句报错？

Question

Select a.BasicInfo_No, b.Detail_Week1_Weight from tb_BasicInfo a  leftjoin  tb_Detail b on a.BasicInfo_No = b.Detail_no系统报错：FROM 子句语法错误。
难道Access数据库与SQL数据库在Join方面还有差异吗？谢谢！

Answer 1

谢谢，left和join中间加个空格可以了，不报错了。但上面的只是个简化的形式，我用以下的真正实用的语句还是报错，如：
Select BasicInfo_No,BasicInfo_LogDate,BasicInfo_Name,iif(BasicInfo_Sex,'男','女') as BasicInfo_Sex,BasicInfo_BirthDay,DATEDIFF('yyyy',BasicInfo_BirthDay,Now()) as BasicInfo_Age,BasicInfo_IDNo,BasicInfo_Speciality,BasicInfo_QQ_MSN,BasicInfo_Telephone,BasicInfo_Address,BasicInfo_Linkman,BasicInfo_Relation,BasicInfo_Homephone,BasicInfo_Cellphone,BasicInfo_LeaveDate,BasicInfo_Height,BasicInfo_Weight,BasicInfo_ChestMeasurement,BasicInfo_Waistline,BasicInfo_HipCircumference,BasicInfo_FatContent,Str(Round(BasicInfo_Weight/BasicInfo_Height/BasicInfo_Height,2)) as BasicInfo_BMI,Detail_Week1_Weight,Detail_Week1_ChestMeasurement,Detail_Week1_Waistline,Detail_Week1_HipCircumference,Detail_Week1_FatContent,Str(Round(Detail_Week1_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week1_BMI,Detail_Week2_Weight,Detail_Week2_ChestMeasurement,Detail_Week2_Waistline,Detail_Week2_HipCircumference,Detail_Week2_FatContent,Str(Round(Detail_Week2_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week2_BMI,Detail_Week3_Weight,Detail_Week3_ChestMeasurement,Detail_Week3_Waistline,Detail_Week3_HipCircumference,Detail_Week3_FatContent,Str(Round(Detail_Week3_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week3_BMI,Detail_Week4_Weight,Detail_Week4_ChestMeasurement,Detail_Week4_Waistline,Detail_Week4_HipCircumference,Detail_Week4_FatContent,Str(Round(Detail_Week4_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week4_BMI,Detail_Week5_Weight,Detail_Week5_ChestMeasurement,Detail_Week5_Waistline,Detail_Week5_HipCircumference,Detail_Week5_FatContent,Str(Round(Detail_Week5_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week5_BMI,Detail_Week6_Weight,Detail_Week6_ChestMeasurement,Detail_Week6_Waistline,Detail_Week6_HipCircumference,Detail_Week6_FatContent,Str(Round(Detail_Week6_Weight/BasicInfo_Height/BasicInfo_Height,2)) as Detail_Week6_BMI from tb_BasicInfo a Left Join tb_Detail b On BasicInfo_No = Detail_No and BasicInfo_No = 'LD-001-001'系统报错：不支持连接表达式。
请问该如何解决，谢谢！

Answer 2

On BasicInfo_No = Detail_No and BasicInfo_No = 'LD-001-001'
未指定这里要指定列所在的表 

Answer 3

把最后的那个and换成where
试过了，没用的。