mysql - SQL 代码在 Excel VBA 中不起作用

Question

我正在使用 Excel 2010 VBA 并从 PGSQL 数据库查询 3 个表

以下 SQL 代码在 MS ACCESS 中运行完美:

SELECT user.surname,user.forename,recall.recalldate,telephone.number
FROM (user INNER JOIN recall ON user.entity_id = recall.master_id) 
LEFT JOIN Telephone ON recall.master_id=Telephone.master_id

但似乎没有转移到 EXCEL VBA:

Dim RECALL As String
RECALL = "SELECT user.surname,user.forename,recall.recalldate,telephone.number " _
        & "FROM (user INNER JOIN recall ON user.entity_id = recall.master_id) " _
        & "LEFT JOIN Telephone ON recall.master_id=Telephone.master_id " _

Set rs = conn.Execute(RECALL)
With ActiveSheet.QueryTables.Add(Connection:=rs, Destination:=Range("A1"))
  .Refresh
End With

我收到一个运行时错误:...FROM 之后的预期表源，得到(

用户表通过user.entity_id = recall.master_id链接到召回表，并显示用户的所有召回记录。然后我需要匹配用户的电话号码。并非所有人都有电话号码，但我需要所有召回，无论他们是否有电话号码。

VBA 中的 SQL 代码有什么问题？

Answer 1

似乎你有一个 () after form try without

 SELECT user.surname,user.forename,recall.recalldate,telephone.number
 FROM  user INNER JOIN recall ON user.entity_id = recall.master_id
 LEFT JOIN Telephone ON recall.master_id=Telephone.master_id