LEFT JOIN

medium

customers LEFT JOIN orders ON ... returns which customers?

Your answer

Only customers with ordersAll customers, with order columns empty when there are noneOnly orders without customersEvery customer paired with every order

Stuck?

Open hints one at a time. The write-up explains a full solution.

Discussion

Ask a question or share a tip. Please don’t post full solutions. Posts appear once a moderator approves them.

No posts yet.

Your name (shown with the post)

Your post