select TAB_A.*, TAB_B.* from TAB_A FULL OUTER JOIN TAB_B ON TAB_A.DW_CODE = TAB_B.DW_CODE (Oracle 9 以上)
select * from table_a,table_b where table_a.Dw_Code = table_b.Dw_Code
select b.a,a.b,b.b from t1 a,t2 b where a.a(+)=b.a union select a.a,a.b,b.b from t1 a,t2 b where a.a=b.a(+)
select TAB_A.*, TAB_B.* from TAB_A ,TAB_B WHERE TAB_A.DW_CODE(+) = TAB_B.DW_CODE UNION select TAB_A.*, TAB_B.* from TAB_A ,TAB_B WHERE TAB_A.DW_CODE = TAB_B.DW_CODE(+)
ON TAB_A.DW_CODE = TAB_B.DW_CODE
(Oracle 9 以上)
from table_a,table_b
where table_a.Dw_Code = table_b.Dw_Code
union
select a.a,a.b,b.b from t1 a,t2 b where a.a=b.a(+)
WHERE TAB_A.DW_CODE(+) = TAB_B.DW_CODE
UNION
select TAB_A.*, TAB_B.* from TAB_A ,TAB_B
WHERE TAB_A.DW_CODE = TAB_B.DW_CODE(+)