Hi, I have a list of IDs on a data frame and I want to extract information for those IDs from an external database. I did a workaround using the "IN" clause in SQL but when the number of IDs is big this method doesn't work. In other words, I want to create a join between a local and a external table using either RODBC() or any other package. Thanks a lot for your help! Orlando -- View this message in context: http://r.789695.n4.nabble.com/Combining-local-data-frame-with-external-data-tp4585355p4585355.html Sent from the R help mailing list archive at Nabble.com.