最佳答案：1) SELECT E.YGNAME as "员工名字"， E.YGBH as "编号"， A.YGYX as "月薪" FROM E, A WHERE E.YGBH=A.YG
1) SELECT E.YGNAME as "员工名字"， E.YGBH as "编号"， A.YGYX as "月薪" FROM E, A WHERE E.YGBH=A.YGBH AND E.YGBM='后勤部'2) select E.* from E,A where E.YGBH=A.YGBH and A.YGYX between 10000 and 50000 and A.NIAN=2007 and A.YUE=7
