problem with applying where condition
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.