日期:2014-05-18  浏览次数:20612 次

一个很白痴的语法问题
database definition:
employee(employee_name,street,city)
works(employee_name,company_name,salary)

然后我的query是这个样子的:
SQL code

(select *
from employee inner join works using (employee_name))
except
(select *
from employee inner join works using (employee_name)
where company_name = 'First Bank Corporation')


except前后的两个句子我都验证过,没有错啊??
有木有人提点下~~
感激不尽~~

------解决方案--------------------
SQL code

select *
from employee inner join works using (employee_name)
except
select *
from employee inner join works using (employee_name)
where company_name = 'First Bank Corporation'