We have two tables:

employees $-$ This table contains each employee$$s ID$,$ name, and department ID$.$

idemployee$\_$namedepartment$\_$id$1$Robert Lyons$42$Vernon Joseph$13$Hazel Mcgee$54$Clancy Wiggum$35$Damon CraigNULL

departments $-$ This table contains each department$$s ID and name.

department$\_$iddepartment$\_$name$1$Sales$2$Engineering$3$Human Resources$4$Customer Service$5$Research And Development

Now you need to join these two tables to include all the employees and their department names. How would you join these two tables? Use SQL code to answer the questions and present the results of your SQL by inserting a table.