SQL Querie - Incorrect syntax error

rstols

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?

SELECT [No_]
,[Visions$Customer].[Name]
,[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
Rudy

kine

You are using wrong syntax, the join is part of FROM definition, not WHERE...

garak

Read this before ....
http://blog.sqlauthority.com/2009/04/13 ... -of-joins/

It explained how to use joinds