hi

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:

SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =
GNORG.COORG) LEFT OUTER JOIN SERVIDOR_CBL.GN_3_0.dbo.GNPAI GNPAI ON
GNORP.CPAIS = GNPAI.COPAI) ORDER BY GNORP.COORG, GNORP.CPAIS

in this case "SERVIDOR_CBL.GN_3_0.dbo.GNPAI" I said the
serverName.BDName.Owner.TableName

But give me an error... Anyone know how can I do this??

Thanks in advance...