Reputation: 67
How can I convert below sql query to R Logic:
SELECT * FROM FRUITS WHERE (ID||TYPE||DATE) NOT IN (SELECT (ID||TYPE||DATE) FROM SEASONAL_FRUITS)
Upvotes: 2
Views: 91
Reputation: 886938
WIth tidyverse
, it would be anti join
library(dplyr)
anti_join(FRUITS, SEASONAL_FRUITS, by = c("ID", "TYPE", "DATE"))
Upvotes: 1