FULL OUTER JOIN
FULL OUTER JOIN
Hello Zoho DB team,
Does Zoho DB & Reports support FULL OUTER JOIN?
It will be great if you could help me to get the following data from Zoho DB. I have two tables containing date and values like:
Table A.
1999-01-01 123
1999-03-08 234
Table B.
1999-01-01 21
1999-04-01 456
From these, I want to run SQL to get
1999-01-01 A.VALUE=123, B.VALUE=21
1999-03-03 A.VALUE=234 B.VALUE=21 // As I don't have value for 199-03-3 in B, I just want to copy the previous value here.
1999-04-01 A.VALUE=234 B.VALUE=456 // As there's no A.VALUE, just copy the previous value for A.
Is this doable?
Thanks.
Minkoo