resolve VBA error "Incorrect syntax near the keyword INNER"

Ukończone Opublikowano 6 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

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

Przetwarzanie danych Excel Architektura oprogramowania Visual Basic Visual Basic for Apps

Numer ID Projektu: #16250400

O projekcie

1 oferta Zdalny projekt Aktywny 6 lat temu

Przyznany użytkownikowi:

filalizakariae

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

$35 AUD w 1 dzień
(3 ocen)
2.5