Next step:Filtering and joins

Automated excerpt

You can have multiple tables in your database eg Customers table and orders table both from the same parent data. Now customers table holds customers info while orders table hold orders info from your parent data. Returns all rows from the left table plus matching data from the right table.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.