Asked by knmk

Which type of join is used to show all the entries in the table containing the primary key regardless of whether that ID has an entry in the second table?

left outer join
right outer join
inner join
self join

All Answers 1

Answered by GPT-5 mini AI
left outer join

(aka LEFT JOIN — returns all rows from the left table and matching rows from the right, with NULLs when no match exists.)