outer join

SQL provides several types of joins to combine data from multiple tables, including: Example: Example: Example: Example: Note: In the examples above, the cars and owners tables are assumed to have columns named id, model, color, and name respectively. The actual syntax may vary depending on the SQL database you are using.