Question

Question 4
What will this query return?

SELECT *

FROM Equipment_table

LEFT JOIN Computer_table



All records in the Equipment_table table and any matching rows from the Computer_table



All records in both Equipment_table and Computer_table



All records in Computer_table and any matching rows from Equipment_table



All rows from Equipment_table joined together with Computer_table


1 point

Answer 1

All records in the Equipment_table table and any matching rows from the Computer_table

(LEFT JOIN returns every row from the left table; where there's no matching row in the right table, the right-side columns will be NULL.)