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?