iampatgrady

-- create two tables: L and R
-- content of tables a "val" column with two rows.
-- rows in L: "left only" and "both"
-- rows in R: "right only" and "both"

with l as (
	select 'both' as val
	union
	select 'left_only' as val
), r as (