Assume the following two tables. Employee table has three fields: EmpID, EmpFname, EmpLname with 120 rows and EmpSkills that has EmpId, SkillID, and SkillDescription with 50 rows. What would be the result of the following SQL statement:
Select EmpFname, EmpLname, SkillDescription
From Employee As Emp Right Outer Join EmpSkills As Emps
On Emp.EmpID = Emps.Empid
a) The query will only return rows where the EmpID in both tables are equal
b) The query will return all rows from Employee, matching rows from EmpSkills, and nulls for EmpSkills columns where there is no match
c) The query will return all rows from EmpSkills, matching rows from Employee, and nulls for Employee columns where there is no match
d) The query will return no rows