consider the following schemes
employee (id, fname, lname)
department (dept_no, dept_name)
project(proj_no, proj_name, dept_no)
works_on(emp_id, proj_no, hours)
the keys are in bold.
I need to find all employees (their names) that are taking part in all of their company's projects.
Aucun commentaire:
Enregistrer un commentaire