select a.LXNAME,a.*,b.MXNAME,b.*,a.LXREV from EMATRIX.LXBO_90BD1412 a,EMATRIX.MXSTATEREQ b where a.LXSTATE=b.MXOID.