Nothing
Code
sql_build(union(lf1, lf2) %>% union_all(lf3))
Output
<SQL SELECT>
From:
<table_path> `lf1`
Select: `lf1`.*, NULL
UNION
<SQL SELECT>
From:
<table_path> `lf2`
Select: `x`, NULL, `z`
UNION ALL
<SQL SELECT>
From:
<table_path> `lf3`
Select: `x`, NULL, `z`
Code
union(lf, lf)
Output
<SQL>
SELECT *
FROM `df`
UNION
SELECT *
FROM `df`
Code
setdiff(lf, lf)
Output
<SQL>
(
SELECT *
FROM `df`
)
EXCEPT
(
SELECT *
FROM `df`
)
Code
intersect(lf, lf)
Output
<SQL>
(
SELECT *
FROM `df`
)
INTERSECT
(
SELECT *
FROM `df`
)
Code
union(lf, lf, all = TRUE)
Output
<SQL>
SELECT *
FROM `df`
UNION ALL
SELECT *
FROM `df`
Code
setdiff(lf, lf, all = TRUE)
Output
<SQL>
(
SELECT *
FROM `df`
)
EXCEPT ALL
(
SELECT *
FROM `df`
)
Code
intersect(lf, lf, all = TRUE)
Output
<SQL>
(
SELECT *
FROM `df`
)
INTERSECT ALL
(
SELECT *
FROM `df`
)
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.