What are the JOINS in SQL?
Use the provided reference data to return each documented join type and its purpose. Include how unmatched rows are handled and preserve the defined display order.
join_type, purpose, unmatched_row_behaviordisplay_order ascending| Column | Type | Description |
|---|---|---|
| join_type_idPK | INT | Unique identifier for the join type |
| join_type | VARCHAR(40) | Name of the SQL join type |
| purpose | TEXT | Typical purpose of the join type |
| unmatched_row_behavior | TEXT | Treatment of rows without a matching row |
| display_order | INT | Required presentation order |