Inner Join- creating the department_dup table
How do I set up departments_dup and how use
CHANGE COLUMN to change the ‘dept_no’ and ‘dept_name’ columns to NULL. Is that the same table departments_dup that I use the change command?
Thanks for reaching out.
I think you are referring to the following two queries.
ALTER TABLE departments_dup CHANGE COLUMN dept_name dept_name VARCHAR(40) NULL; ALTER TABLE departments_dup CHANGE COLUMN dept_no dept_no CHAR(4) NULL;
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.