[R] Query about merging two tables

[lalitha viswanath]

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