search for: alwaysincrement

Displaying 1 result from an estimated 1 matches for "alwaysincrement".

2010 Jul 25
1
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, -9999999) as alwaysIncrement FROM tab1 LEFT OUTER JOIN tab2 On tab1.data1 - tab2.mouseX = 0 And tab1.data2 - tab2.mouseY = 0 I am trying to do the following in R:- *#Getting error here:* data <- merge(tab1,tab2, all.x=TRUE, by=(data$data1 - data$mouseX == 0), by=(data$data2 - data$mouseY == 0)) data &l...