write by a programer
SELECT a.a1,a.a2,b.b1,b.b2 FROM(SELECT a1,a2 FROM TB_A) a FULL JOIN (SELECT b1,b2 FROM TB_B)b ON a.a1=b.b1