❤️ Thank you to everyone who supported the project! Last month you donated almost $100 — this keeps the service running free for everyone this month. I hope to count on your support for next month too. Support now →
SQL code copied to buffer
RU PT FR
Task 22:

Choose tables join type

Imagine you have two tables: customer and customer_addresses, each containing a column named customer_id.
What type of JOIN would you use in a query to get all customer records clients (even if they don't have an address) and the addresses of those that have a corresponding address entry in the  table customer_addresses?

Mark all correct answers and click the "Check!" button

Get hint

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.