sql.join {dbi.table} | R Documentation |
Join dbi.table
s
Description
A SQL
-like join of two dbi.table
s that share the
same DBI connection
. All columns from
both dbi.table
s are returned.
Usage
sql.join(x, y, type = "inner", on = NULL, prefixes = c("x.", "y."))
Arguments
x , y |
|
type |
a character string specifying the join type. Valid choices are
|
on |
a |
prefixes |
a 2-element character vector of distinct values. When |
Value
a dbi.table
.
Examples
chinook <- dbi.catalog(chinook.duckdb)
Album <- chinook$main$Album
Artist <- chinook$main$Artist
sql.join(Album, Artist, type = "inner",
on = Album.ArtistId == Artist.ArtistId,
prefixes = c("Album.", "Artist."))