🙏 Help keep this project alive. Last month we raised only $32 - enough for servers only. Without your support, there will be no new lessons or features. 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.