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

情報処理 エクセル ソフトウェアアーキテクチャ ビジュアルベーシック アプリ用ビジュアルベーシック

プロジェクト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