110,534
社区成员
发帖
与我相关
我的任务
分享
select a.ID,isnull(b.Remark,a.Name) as Name,a.Age from stu as a left join Info as b on a.ID=b.Uid
select a.ID,(case when b.Remark is null then a.Name else b.Remark end) as Name,
a.Age from Stu as a left join Info as b on a.ID=b.Uid
select a.id,(case when b.Remark is null then a.Name else b.Remark end) as Name ,a.age from Stu a,Info b where a.id = b.uid