标签： mysql-select-db

我在mysql中创建了这个CREATE VIEW MYVIEW AS ( SELECT A.FNAME , A.LNAME , B.EMAIL FROM EMPLOYEE A, EMPEMAIL B WHERE A.EID = :empId AND A.EID = B.EID AND B.EMAILTYP = :emailType)