over 4 years ago
<-- Chapter 24: SQL Aliases
SQL Joins clause are used to combine data rows from two or more than two tables according to common field values between them.
Lets see an examples from the below tables "customers" :-
Lets see an examples from the below tables "orders" :-
SQL JOIN syntax :-
SELECT `customers`.`name` AS [Customer Name], `orders`.`date` AS `Date`
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.
There are different SQL Joins :-
We will learn about all these JOINS in coming chapters.
Chapter 26: SQL Inner 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