ON suppliers.supplier_id = orders.supplier_id Here is an example of a MySQL INNER JOIN: SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date The MySQL INNER JOIN would return the records where table1 and table2 intersect. In this visual diagram, the MySQL INNER JOIN returns the shaded area: The syntax for the INNER JOIN in MySQL is: SELECT columns MySQL INNER JOINS return all rows from multiple tables where the join condition is met. Chances are, you've already written a statement that uses a MySQL INNER JOIN.
0 Comments
Leave a Reply. |