select MobileInfo.Mobile,
case when MobileState=0 then '未用'
when MobileState=1 then '待用'
when MobileState=2 then '已用' end as MobileState,
UserName,LoginName
from UserInfo,MobileInfo
where UserInfo.MobileGUID=MobileInfo.MobileGUID 这些上面的都对可以查询
现在想在最后一句where UserInfo.MobileGUID=MobileInfo.MobileGUID 后面加上
在UserInfo.MobileGUID中没有出现的MobileInfo.MobileGUID 也一起显示怎么办?
--TRY
select MobileInfo.Mobile,
case when MobileState=0 then '未用'
when MobileState=1 then '待用'
when MobileState=2 then '已用' end as MobileState,
UserName,LoginName
from UserInfo
LEFT JOIN MobileInfo
ON UserInfo.MobileGUID=MobileInfo.MobileGUID
case when MobileState=0 then '未用'
when MobileState=1 then '待用'
when MobileState=2 then '已用' end as MobileState,
UserName,LoginName
from UserInfo right join MobileInfo on
UserInfo.MobileGUID=MobileInfo.MobileGUID