Hello,
You can merge both tables first and then select the rows and columns you
want. Do it the other way around if your tables are too big.
All you need you can read it at
?merge
?subset
Best regards,
Carlos J. Gil Bellosta
http://www.datanalytics.com
On Tue, 2009-01-20 at 11:03 +0530, venkata kirankumar
wrote:> Hi all,
>
> I am a biggener in R-Project
>
> I got one problem with applying *where condition*
> like
>
> if 2 tables like
> table1:
>
> empid name dep
> 101 kiran solutions
> 102 ram testing
> 103 pavan database
>
> table2:
>
> empid month sal
> 101 Dec 9500
> 102 Dec 9800
> 103 Dec 8500
>
> in first table i have to take *empid* with using the *name(kiran)*
> and after getting that *empid* i have to get *sal *with using that *empid*
>
> can any one suggest how can I acheave this
>
>
> Thanks & regards;
> kiran
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.