Multiple joins

[Luciano]

Hi, i want to select some fields from multiple joins but it does not run in
access.

In SQL Server it is ease, but in Access is not.
Please help me with the query above:

SELECT Ocorrencia.*, UsuarioCliente.cSigla AS cSiglaUsuarioCliente,
UsuarioTecnico.cSigla AS cSiglaUsuarioTecnico, Cliente.cNmCliente
FROM ((Ocorrencia
LEFT JOIN Usuario AS UsuarioCliente ON Ocorrencia.IdUsuarioCliente =
UsuarioCliente.ID)
LEFT JOIN Usuario AS UsuarioTecnico ON Ocorrencia.IdUsuarioTecnico =
UsuarioTecnico.ID)
INNER JOIN Cliente ON UsuarioCliente.IDCliente = Cliente.ID
WHERE Ocorrencia.ID = 036

ERROR:
Microsoft JET Database Engine erro '80040e14'

Thanks, and sorry my bad English.

Luciano from Brazil

 

[[MVP] S.Clark]

You may need to change the one Inner Join to a Left or Right join.