I need to find the number of
employees who are not in all departments.
I have one more table
T2 in which same department column is present. Now I want to insert only those values of
department which are not in
T1.Department for those employees whose name doesn't appear in all 37 departments.
I'm using MySQL.
Do I need to make any procedure for this?
create table T1 (empname, department)
create table T2 (department)