Joins

SQL joins similar to {dplyr} joins

flights |> 
  left_join(planes |> rename(year_built = year), by = "tailnum") |> 
  show_query()

## <SQL>
## SELECT
##   flights.*,
##   planes."year" AS year_built,
##   "type",
##   manufacturer,
##   model,
##   engines,
##   seats,
##   speed,
##   engine
## FROM flights
## LEFT JOIN planes
##   ON (flights.tailnum = planes.tailnum)