帮忙看一下，急

Question

department表没有部门ID？否则
select employee.名字
from company a,department b,employee c
where a.id=? and a.id=b.id and b.id=c.id

Answer 1

SELECT company.名字,mployee.雇员名字 FROM company,department,employee WHERE company.id = department.id AND department.部门id = employee包括部门id.

Answer 2

department表还应该有部门id吧，SELECT company.名字,mployee.雇员名字 FROM company,department,employee WHERE company.id = department.id AND department.部门id = employee包括部门id.

Answer 3

有部门id,公司表里也有公司id,部门表里也有公司id.