试试看：
select coalesce(t1.date, t2.date, t3.date) date, col1, col2, col3 from table1 t1full outer join table2 t2 on (t1.date = t2.date)full outer join table3 t3 on (t2.date = t3.date)
试试看：
select coalesce(t1.date, t2.date, t3.date) date, col1, col2, col3 from table1 t1full outer join table2 t2 on (t1.date = t2.date)full outer join table3 t3 on (t2.date = t3.date)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
