I have 3 tables:
Employee (EmployeeNo(PK),shopID(FK1) employeeName, employeeAddress)
Shop (shopID(PK), shopName, shopAddress)
Comment (EmployeeNo(FK), employeeComments)
Is it possible to run a query showing the names of all the employees who have left a comment in the comments table even if the employee name is not in the table?