Re: [R] Left Outer Join 2 DF's on Multiple Conditions

Look at sqldf package, it is easier to do sql like statements with it. Nikhil Kaza Asst. Professor, City and Regional Planning University of North Carolina nikhil.l...@gmail.com On Jul 25, 2010, at 6:10 PM, harsh yadav wrote: Hi, I am trying to execute the following SQL statement using two d

[R] Left Outer Join 2 DF's on Multiple Conditions

Hi, I am trying to execute the following SQL statement using two data frames: tab1, tab2 : Two Tables Select tab1.*, tab2.*, tab1.tobiiTime - tab2.ruiTime as timeDiff, IFNULL(n-m, -999) as alwaysIncrement FROM tab1 LEFT OUTER JOIN tab2 On tab1.data1 - tab2.mouseX = 0 And ta