Hello Everyone
I am new on the Mr Excel forum. Could someone please assist me with the below SQL RIGHT OUTER JOIN statement included in an excel <acronym title="visual basic for applications">VBA</acronym> script.
MySql = "SELECT Employees.[First Name], employees.[Last Name], employees.[Job Title] " & _
"orders.[Ship City], orders.[Ship Country/Region] " & _
"orders.[Order ID] , orders.[Ship Name], orders.Taxes " & _
"FROM Employees " & _
"RIGHT OUTER JOIN Orders " & _
"ON Employees.ID = orders.[Employee ID] " & _
"order by orders.[Ship Address];"
When i run the program, i am getting the below error message box
-- removed inline image ---
Is
I am new on the Mr Excel forum. Could someone please assist me with the below SQL RIGHT OUTER JOIN statement included in an excel <acronym title="visual basic for applications">VBA</acronym> script.
MySql = "SELECT Employees.[First Name], employees.[Last Name], employees.[Job Title] " & _
"orders.[Ship City], orders.[Ship Country/Region] " & _
"orders.[Order ID] , orders.[Ship Name], orders.Taxes " & _
"FROM Employees " & _
"RIGHT OUTER JOIN Orders " & _
"ON Employees.ID = orders.[Employee ID] " & _
"order by orders.[Ship Address];"
When i run the program, i am getting the below error message box
-- removed inline image ---
Is