SQL set operationsSource:
- x, y
A pair of lazy data frames backed by database queries.
yare not from the same data source, and
ywill be copied into a temporary table in same database as
*_join()will automatically run
ANALYZEon the created table in the hope that this will make you queries as efficient as possible by giving more data to the query planner.
This allows you to join tables across srcs, but it's potentially expensive operation so you must opt into it.
Not currently used; provided for future extensions.
TRUE, includes all matches in output, not just unique rows.