外连接，左连接查询两个表的数据

select t1.id ,t1.jhfsid,t1.jgsm,t2.zrsm from t t1 full outer join tt t2 on (t1.id = t2.id)

   

select t1.*,t2.* from t t1 left join tt t2 on t1.ID = t2.ID

SELECT t1.id,t1.jhfsid,jgsm,zrsm FROM t t1, tt t2 WHERE t1.id = t2.id(+)
UNION
SELECT t2.id, t2.jhfsid, jgsm,zrsm FROM t t1, tt t2 WHERE t1.id(+) = t2.id;