-
Notifications
You must be signed in to change notification settings - Fork 982
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
New Argument: "join". Objective: ANSI SQL Syntax #3946
Comments
I think if we want to add the new argument, merge.data.table is a better place to have this. |
There is a plan to support syntax similar to the one proposed in this issue. I think there is an open issue for that. |
For me, it shall be implemented both in the data.table DT[X] Join Syntax, and in merge.data.table. As DT[X] allows non-equi joins. As pointed out before, the objective of this is to transform Y[X, join = "left"] to X[Y] :) |
I vote for this too. Switching the X and Y position to perform left join changes the entire order of columns. |
Could data.table add a new argument, "join", that instead of using the 'deafult' data.table's own joining syntax, uses that of ANSI SQL.
Where join = c('default', 'left', 'right', 'inner', 'outer').
So that:
Thank you!
The text was updated successfully, but these errors were encountered: