select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id and t1.cd='A'select t1.id,t1.cd,t2.name from t1 left outer j
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id and t1.cd='A'select t1.id,t1.cd,t2.name from t1 left outer j