S——table

SELECT A.LOGIN,EMAIL_ADDR,LAST_NAME
from S_USER A
JOIN S_CONTACT B on A.ROW_ID=B.ROW_ID
where  A.ROW_ID='1-3T31A'