SQL Querie - Incorrect syntax error

rstolsrstols Member Posts: 28
edited 2009-09-10 in SQL General
I tried to create a querie to list the customer no, customer name and the location name.
The WHERE condition is giving me an error (Incorrect syntax near the keyword 'INNER'.) and I am not sure how to fix it?

,[Visions$Location].[Name] AS [Location Name]
FROM [Visions$Customer] WHERE [Customer Posting Group] = 'TELUS'
INNER JOIN [Visions$Location] ON
[Visions$Customer].[Location Code] = [Visions$Location].[Code]

I'll appreciate any help to fix the querie?

Thank you


Sign In or Register to comment.