一个很白痴的语法问题
database definition:
employee(employee_name,street,city)
works(employee_name,company_name,salary)
然后我的query是这个样子的:
(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')
select *from employee inner join works using (employee_name)exceptselect *from employee inner join works using (employee_name)where company_name = 'First Bank Corporation'