Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on May 11, 2016 2:18AM
Likes: 2
Replies: 2
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'