[R] Query about merging two tables

lalitha viswanath lalithaviswanath at yahoo.com
Tue Feb 6 16:15:08 CET 2007


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



More information about the R-help mailing list