>Hi i have to table with IDs in each one. >I want to make a join (as in sql) by the ID. Is any way to use the RODBC >package (or other) in local tables (not a access, mysql, sql, etc. ) and >made the join? With RODBC it would be normal SQL, so I guess with local tables you mean data frames? then look at ?merge best wishes ido