multiple joins

L

Luciano

Hi, i want to select some fields from multiple joins but it does not run in
access.
In SQL Server it look like ease, but 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
 
Top