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@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. ______________________________________________ R-help@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.
