摘要： 1. 根據(jù)表A， 表B，計(jì)算表C select coalesce(A.dt, B.dt) as dt, coalesce(A.colA, 0) as colA, coalesce(B.colB, 0) as colB from A full outer join B on a.dt = b.dt; 閱讀全文