sd_join_select.RdUse sd_join_select() to specify which columns to include in the join
result and optionally rename them. Columns may be referenced using
x$column and y$column syntax to disambiguate columns from the left
and right tables, or by bare column name when the name exists on only
one side of the join.
sd_join_select(...)Named expressions specifying output columns. Each expression
may reference a column using x$column or y$column syntax, or use
a bare column name when it is unambiguous. If the same column name
exists on both sides of the join, it must be qualified with x$ or
y$. The name of the argument becomes the output column name. Unnamed
arguments use the original column name (without table prefix).
An object of class sedonadb_join_select containing the
unevaluated column selection expressions.
# Select and rename columns
sd_join_select(id = x$id, left_value = x$value, right_value = y$value)
#> <sedonadb_join_select>
#> id = x$id
#> left_value = x$value
#> right_value = y$value
# Unnamed arguments keep original column name
sd_join_select(x$id, x$name, y$value)
#> <sedonadb_join_select>
#> x$id
#> x$name
#> y$value