Support ongoing development - donate to help us maintain and improve the platform. 🖥️ Support sqltest →
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 answers" button

The check result will appear here.

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

Privacy & Cookie Policy.