DB2 左外连接 ,条件的有关问题
DB2 左外连接 ,条件的问题
语句中条件 t2.cd 没起作用,怎么办???
------解决方案--------------------
是t1.cd?
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id
where t1.cd='A'
------解决方案--------------------
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id
where t1.cd='A'
- SQL code
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id and t1.cd='A'
语句中条件 t2.cd 没起作用,怎么办???
------解决方案--------------------
是t1.cd?
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id
where t1.cd='A'
------解决方案--------------------
select t1.id,t1.cd,t2.name from t1 left outer join t2 on t1.id=t2.id
where t1.cd='A'