Excel SQL

loumin00

那位大侠能帮忙看看下面的代码到底错在哪儿了？一直提示：

Sql = "select A.Date, A.Work_center, B.Max(Actual_working_hours) from " _
        & "(select DISTINCT Date, Work_center from [125_Basic_Aggregation$]) as A LEFT JOIN " _
        & "select Date, Work_center, Max(Actual_working_hours) from [131_Basic_W-arrange$BA5:BO10000] group by Date, Work_center as B" _
        & " on A.Date = B.Date, A.Work_center = B.Work_center"

xiaoyu2055

谢谢分享呀

amazeyeli

a你会用()括起来,b你就不会了?我晕
然后再运行到B.Max(Actual_working_hours)也会报错:没有为字段指定别名

loumin00

amazeyeli 发表于 2013-8-9 14:17
a你会用()括起来,b你就不会了?我晕
然后再运行到B.Max(Actual_working_hours)也会报错:没有为字段指定别名 ...

B不能用括号的，我试过了，会报错的，说：不支持链接; 其实A也没用括号，括号用在A的子查询的。
应该写B.Max(Actual_working_hours） 还是Max(B.Actual_working_hours)??

Sql = "select A.Date, A.Work_center, B.Max(Actual_working_hours) from " _
        & "(select DISTINCT Date, Work_center from [125_Basic_Aggregation$]) as A LEFT JOIN " _
        & "select Date, Work_center, Max(Actual_working_hours) from [131_Basic_W-arrange$BA5:BO10000] group by Date, Work_center as B" _
        & " on A.Date = B.Date, A.Work_center = B.Work_center"

现在报一样的错误！

loumin00

哪儿高手帮帮忙，整了一天了，就是搞不定！！
现上传附件，谢谢！

loumin00

loumin00 发表于 2013-8-9 16:47
哪儿高手帮帮忙，整了一天了，就是搞不定！！
现上传附件，谢谢！

问题已解决，还是自己发现了错误：

Sql = "select A.Date, A.Work_center, B.Max(Actual_working_hours) from " _
        & "(select DISTINCT Date, Work_center from [125_Basic_Aggregation$]) as A LEFT JOIN " _
        & "(select Date, Work_center, Max(Actual_working_hours) from [131_Basic_W-arrange$BA5:BO10000] group b Date, Work_center) as B" _
        & " on A.Date = B.Date and A.Work_center = B.Work_center"