SELECT姓名,仓库名FROM保管工; WHERE工资>1500 SELECT姓名,仓库名FROM仓库; WHERE工资>1500 SELECT姓名,仓库名FROM保管工,仓库; WHERE(工资>1500)OR(保管工.仓库号=仓库.仓库号) SELECT姓名,仓库名FROM保管工,仓库; WHERE(工资>1500)AND(职工.仓库号=仓库.仓库号)
SELECT 姓名,仓库名 FROM 保管工; WHERE 工资>1500 SELECT 姓名,仓库名 FROM 仓库; WHERE 工资>1500 SELECT 姓名,仓库名 FROM 保管工,仓库; WHERE (工资>1500) OR (保管工.仓库号=仓库.仓库号) SELECT 姓名,仓库名 FROM 保管工,仓库; WHERE (工资>1500) AND (职工.仓库号=仓库.仓库号)
SELECT 姓名,仓库名 FROM 保管工; WHERE 工资>1500 SELECT 姓名,仓库名 FROM 仓库; WHERE 工资>1500 SELECT 姓名,仓库名 FROM 保管工,仓库; WHERE(工资>1500) OR (保管工.仓库号=仓库.仓库号) SELECT 姓名,仓库名 FROM 保管工,仓库; WHERE(工资>1500) AND (职工.仓库号=仓库.仓库号)