SELECT TU.USERID, TU.USERNAME, TU.PASSWORD, TU.GROUPIDEN, TU.ROLEID , TUI.REALNAME, TUI.GENDER, TUI.BIRTHDAY, TUI.PERSONID, TUI.EMAIL, TUI.MOBILENUMBER , TUS.JOBNUMBER, TUS.COMPANYID FROM TAB_USER TU, TAB_USER_INFO TUI, TAB_USER_STAFF TUS , TUC.ADDRESS, TUC.AREAID FROM TAB_USER TU, TAB_USER_INFO TUI, TAB_USER_CONSUMER TUC WHERE TU.USERID = TUI.USERID AND TU.USERID = TUS.USERID AND TUI.USERID = TUS.USERID AND TU.USERNAME = #{userName} TU.USERID = TUI.USERID AND TU.USERID = TUC.USERID AND TUI.USERID = TUC.USERID AND TU.USERNAME = #{userName} 这样试试呢？
