🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 40:

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?

Choose one answer and click the "Check answers" button

Tutorial
The check result will appear here.