Question

which results would show if the employee table left joined the customer table? all rows from the customer table even if they don't have an employee supporting them only employees that have customers that they support only customers that have employees associated with them and vice-versa all employees, even those that aren't supporting customers

Answer 1

If the employee table left joins the customer table, all employees would be included in the result, even those who aren't supporting customers.

Step-by-step explanation:

If the employee table left joins the customer table, the result would be all employees, even those that aren't supporting customers. A left join includes all rows from the left table (employee table) and the matched rows from the right table (customer table). In this case, the left table is the employee table, so all employees would be included in the result, regardless of whether they have customers supporting them or not.