resolve VBA error "Incorrect syntax near the keyword INNER"

已完成 已发布的 6 年前 货到付款
已完成 货到付款

Running the below VBA in excel and receiving the error "Incorrect syntax near the keyword INNER" - please advise correction in syntax to run code successfully:

Dim strSQL As String

strSQL = "DELETE " & _

"FROM data_MonthlyBudget " & _

"INNER JOIN source_Versions on [url removed, login to view] = [url removed, login to view] " & _

"INNER JOIN source_TemplateSource on [url removed, login to view] = [url removed, login to view] " & _

"WHERE BudgetVersion = '" & Worksheets("CONFIG").Range("C4").Value & "' " & _

"AND [url removed, login to view] = '" & Worksheets("CONFIG").Range("C4").Value & "' " & _

"AND [url removed, login to view] = 'MonthlyBudget'"

[url removed, login to view] strSQL

[url removed, login to view] strSQL

数据处理 Excel 软件构架 Visual Basic Visual Basic的应用程式

项目ID: #16250400

关于项目

1个方案 远程项目 活跃的6 年前

授予:

filalizakariae

its an sql issue not vb, I'll fix it for you if you want

$35 AUD 在1天内
(3条评论)
2.5