thank you! I was able to get it to work with collapse="," On Wed, 2011-10-19 at 01:52 -0500, Jeff Newmiller wrote: > paste("SELECT * FROM this_table WHERE this_column IN (", > paste(org_table$id, collapse=TRUE),")",sep="")