resolve VBA error "Incorrect syntax near the keyword INNER"

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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

Data Processing Excel Software Architecture Visual Basic Visual Basic for Apps

Project ID: #16250400

About the project

1 proposal Remote project Active 6 years ago

Awarded to:

filalizakariae

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

$35 AUD in 1 day
(3 Reviews)
2.5