SQL多表查询问题
本帖最后由 shengvssi001 于 2010-7-24 15:18 编辑
表 【员工】 【部门】
-----------------------------------------
department【部门】
DNAME DNUMBER MGRSSN MGRSTARTDATE
Headquarters 1 888665555 1981/6/19
Administration 4 987654321 1995/1/1
Research 5 333445555 1988/5/22
--------------------------------------------
employee【员工】
FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO
John B Smith 123456789 1965/1/9 731 Fondren, Houston,TX M 30000 333445555 5
Franklin T Wong 333445555 1955/12/8 638 Voss, Houston,TX M 40000 888665555 5
Ramesh K Narayan 666884444 1962/9/15 975 Fire Oak, Humble, TX M 38000 333445555 5
James E Borg 888665555 1937/11/10 450 Stone, Houston, TX M 55000 1
Jennifer S Wallace 987654321 1941/6/20 291 Berry, Bellaire, TX F 43000 888665555 4
Ahmad V Jabbar 987987987 1969/3/29 980 Dallas, Houston, TX M 25000 987654321 4
Alicia J Zelaya 999887777 1968/7/19 3321 Castle, Spring, TX F 25000 987654321 4
------------------------------------------------------------------------------------------------------------------------
题目如下:
查询有两个或以上“工资大于等于30000员工”的部门名称