| Line 93... |
Line 93... |
| 93 |
% Terminology follows https://en.wikipedia.org/wiki/Join_(SQL)
|
93 |
% Terminology follows https://en.wikipedia.org/wiki/Join_(SQL)
|
| 94 |
In SQL database terminology, the default value of \code{all = FALSE}
|
94 |
In SQL database terminology, the default value of \code{all = FALSE}
|
| 95 |
gives a \emph{natural join}, a special case of an \emph{inner
|
95 |
gives a \emph{natural join}, a special case of an \emph{inner
|
| 96 |
join}. Specifying \code{all.x = TRUE} gives a \emph{left (outer)
|
96 |
join}. Specifying \code{all.x = TRUE} gives a \emph{left (outer)
|
| 97 |
join}, \code{all.y = TRUE} a \emph{right (outer) join}, and both
|
97 |
join}, \code{all.y = TRUE} a \emph{right (outer) join}, and both
|
| 98 |
(\code{all = TRUE} a \emph{(full) outer join}. DBMSes do not match
|
98 |
(\code{all = TRUE}) a \emph{(full) outer join}. DBMSes do not match
|
| 99 |
\code{NULL} records, equivalent to \code{incomparables = NA} in \R.
|
99 |
\code{NULL} records, equivalent to \code{incomparables = NA} in \R.
|
| 100 |
}
|
100 |
}
|
| 101 |
|
101 |
|
| 102 |
\note{
|
102 |
\note{
|
| 103 |
This is intended to work with data frames with vector-like columns:
|
103 |
This is intended to work with data frames with vector-like columns:
|