03-18-2015 12:06 AM
I have two set of data which are policy (table 1) and claim (table 2) data. Multiple claims have been subtotal by policy no. I have merged these data by policy no. level yet there are blank cell in between when I pull only policy no. from table 1 and vice versa. How do I merge policy no. from table 1 and table 2 into one column other than doing formulae by adding new column?
03-18-2015 06:15 AM
select coalesce(a.policy_no,b.policy_no) as policy_no
from policy a full join claim b on a.policy_no = b.policy_no;