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'