I have a table that contains sales records: Sale ID EmployeeId(FK) Employee 2 … 1 101 Null … 2 102 Null … 3 300 Bob … … … … … I have another table that contains employee records: EmployeeId EmployeeName … 101 Amanda … 102 Bob … … … … 300 cicilia … … … […]