Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Here it is (with the partition named "date"):
select
COALESCE("input1"."date", "input2"."date") as "date",
...
from "input1"
full outer join "input2"
... and "input1"."date" = "input2"."date"
where
"input1"."date" = '$DKU_DST_date' or "input2"."date" = '$DKU_DST_date'