3,491
社区成员
发帖
与我相关
我的任务
分享
SELECT NAME,
(SELECT SEXNAME FROM TBL_SEX B WHERE A.SEXNO = B.SEXNO) AS SEXNAME
FROM TBL_PERSON A
WHERE CERTNO = '3404031';
SELECT NAME, A.SEXNAME
FROM TBL_PERSON A
LEFT JOIN TBL_SEX B ON A.SEXNO = B.SEXNO
WHERE CERTNO = '3404031';
SELECT NAME, B.SEXNAME
FROM TBL_PERSON A
LEFT JOIN TBL_SEX B ON A.SEXNO = B.SEXNO
WHERE CERTNO = '3404031';