Hi all,

I have some trouble joining the results from 2 tables in SQL Server with ADO,

Ex:

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

The result is not what i expected, and i don't know if is that possible with this sintax!!!

Is anything wrong, or other way to do that

João Batista