select * from t1 full join t2 on t1.id = t2.id;