Hi I have table1 which has the foll. columns id age rate and table2 which has the foll. columns id count
I wish to get data from table1 for all the ids which are persent in table2 and where the rate is not equal to 999. The ids in table2 are a subset of those in table1 and every id in table2 has an entry in table1. I would appreciate your input regarding the above. Thanks in advance Lalitha ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.