SQL Join Types

Click a join type to see the Venn diagram, SQL syntax, and result set

Table A (Customers) Table B (Orders)

SQL Syntax


                

Sample Result