why didnt we use just use the dept_emp for the emp_no and dept_id ?
why didn't we just use the dept_emp for the emp_no and dept_id ? why did we needed the employees table for .or was is just to train on the join functoin
1 answers ( 0 marked as helpful)
Hi Ismail!
Thanks for reaching out!
Sometimes, a task can be solved in more than one way. In this particular situation, you can retrieve the desired columns by using the dept_emp table, but you can also use a join. I suppose it is good to use a join for the sake of training.
Hope this helps.
Best regards,
Martin