>Ok, could you please post the statement again? Does it work as expected in
>SQL Server? Any other relevant info?

lcCommand = "select * from tgccodDocArm a LEFT OUTER JOIN tgcCodArm b ON
b.c_codigo=a.c_armazem where a.c_codigo = '" + tcID + "'"
llOK = .oData.GetRecordSet(toRS, lcCommand)

With Query Analyser it works.

The only thing is that, i create a blank recordset with the struture from the table tgcCodDocArm, before i pass them to this select then in this recordset i want to join the tgcCodArm.

João