Below are different tables and diagrams for SQL joins. So, these illustrations show seven connections between two tables.
SQL joins table
The diagram below shows the original table, and the results of each join structure.
SELECT syntax for joining tables
Related
- ASCII character code table – Reference guide
- Color scheme table for Excel
- Using the FILTER function in Excel – Snapshot