resolve VBA error "Incorrect syntax near the keyword INNER"

Fullført Lagt ut 6 år siden Betales ved levering
Fullført Betales ved levering

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

Databehandling Excel Programvarearkitektur Visual Basic Visual Basic for apper

Prosjekt-ID: #16250400

Om prosjektet

1 bud Eksternt prosjekt Aktiv 6 år siden

Tildelt til:

filalizakariae

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

$35 AUD på 1 dag
(3 omtaler)
2.5