一个很白痴的语法问题
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)exceptselect *from employee inner join works using (employee_name)where company_name = 'First Bank Corporation'