Selesai

resolve VBA error "Incorrect syntax near the keyword INNER"

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

Keahlian: Pemrosesan Data, Excel, Perancangan Perangkat Lunak, Visual Basic, Visual Basic untuk Aplikasi

Tentang Pemberi kerja:
( 20 ulasan ) Adelaide, Australia

ID Proyek: #16250400

Diberikan kepada:

filalizakariae

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

$35 AUD dalam 1 hari
(3 Ulasan)
2.5