Issue with SQL RIGHT OUTER JOIN in Excel VBA

[elysieum]

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 VBA 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 ---


Could someone please shed a light on the issue? How do i go about resolving the issue?

I am grateful in advance for your assistance

 

[par60056]

Your post came through poorly.

Looking at the SQL, you need a comma [Job Title] and .[Ship Country/Region]

 

[elysieum]

apologies for the poor presentation of data. This is my first time using this technology. Find below the sql code in VBA environment.

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 get the below error message

Runtime time - 'error 2147217900(80040e14)':
Incorrect syntax near '.'.

Thanks

 

[Fazza]

hi

there is an extra comma, "orders.Taxes, FROM Employees"

If you're querying Access, suggest you test the SQL in an MS Access database.

If you're querying Excel, the outer join syntax is different. MS Query help refers: please refer MS Query help. It is also described at http://support.microsoft.com/kb/136699

HTH

 

[elysieum]

Hi Fazza

I am so grateful for your assistance. The program now works after removing the comma. I am actually querying MS SQL Server 2012.


Million thanks