第一问答网»论坛 › 中问网 › 问答 › Access 里的sql语句出错提示语法错误操作符丢失 ...

Access 里的sql语句出错提示语法错误操作符丢失

11 |

2 | 2011-8-9 13:53:30 | 显示全部楼层 |阅读模式

sql1 = "Select * From tqhz Main Left Join ( Select f02,f03,Sum(f05)as f01 From tqsrGroup By f02,f03 )Tmp On Main.f02=Tmp.f02 and Main.f03=Tmp.f03 Left Join ( Select t02,t03,Sum(t04) as t04 From tqzc Group By t02,t03)Tmp1 On Main.f02=Tmp1.t02 and Main.f03=Tmp1.t03"

使用道具举报