🙏 Thank you for your support last month! Thanks to you, the project keeps growing. We'd be grateful if you could support us again this month. Support again →
SQL code copied to buffer
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.