效率问题大家帮忙看下，感激不尽

SELECT MEMBER_ID,
(SELECT MEMER_PASSPORD FROM MEMBER_PASSWORD WHERE MEMBER_ID ='123456')
as password FROM MEMBER_BASE_INFO WHERE MEMBER_ID ='123456'
AND MEMBER_STATUS = 0和
select m.MEMBER_ID,mp.MEMER_PASSPORD from MEMBER_BASE_INFO as m
left join MEMBER_PASSWORD as mp on m.MEMBER_ID=mp.MEMBER_ID
where m.MEMBER_ID='123456' AND m.MEMBER_STATUS = 0这两条语句都能实现功能，请问那条效率最高