select ISNULL(B.name,A.username) tname,
ISNULL(B.addr,A.useraddress) TADDRESS,
ISNULL(B.phone,A.userphone) tphone,
ISNULL(B.email,A.useremail) temail
from edu_baomin A LEFT OUTER JOIN
(SELECT * FROM TCARD WHERE cardno IN(SELECT cardno FROM edu_baomin WHERE usertype = 1)) B ON A.cardno = B.cardno
where A.EDU_ID=3
ISNULL(B.addr,A.useraddress) TADDRESS,
ISNULL(B.phone,A.userphone) tphone,
ISNULL(B.email,A.useremail) temail
from edu_baomin A LEFT OUTER JOIN
(SELECT * FROM TCARD WHERE cardno IN(SELECT cardno FROM edu_baomin WHERE usertype = 1)) B ON A.cardno = B.cardno
where A.EDU_ID=3
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货