over 4 years ago
<-- Chapter 25: SQL Join
SQL Inner Join clause is used to fetch all the rows from more than two tables in which there is a match between the columns. Inner Join is similar like Join clause.
Lets see an examples from the below tables "customers" :-
Lets see an examples from the below tables "orders" :-
SQL JOIN SQL syntax :-
SELECT `customers`.`name` AS [Customer Name], `orders`.`date` AS `Date`
INNER JOIN `customers`
ON `orders`.`customer_id` = `customers`.`customer_id`;
Now run the above SQL query, we will see the output below :-
Now we can see here, we have displayed customer name and order date of customer on the basis of common customer_id between customers and orders tables.
Chapter 27: SQL Left Join -->
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using