مرکز آموزش
دستور Inner Join
SQL INNER JOIN Keywordدستور مربوطه تمامی ردیف های مشترک دو جدول را که در یک ستون خاص مشترک هستند انتخاب می کند The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.
SQL INNER JOIN Syntaxبه دو روش زیر می توان از این دستور استفاده نمود : SELECT column_name(s)
FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name; or: SELECT column_name(s)
FROM table1 JOIN table2 ON table1.column_name=table2.column_name; PS! INNER JOIN is the same as JOIN. Demo Databaseدر بانک اطلاعاتی زیر دو جدول که شامل جدول مشتریان و جدول سفارشات دیده می شود: In this tutorial we will use the well-known Northwind sample database. Below is a selection from the "Customers" table:
And a selection from the "Orders" table:
SQL INNER JOIN Exampleبرای مثال پرس و جوی زیر تمامی سفارشات مشتریان را به عنوان خروجی نشان خواهد داد : The following SQL statement will return all customers with orders: ExampleSELECT Customers.CustomerName, Orders.OrderID
FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerName; Try it yourself » Note: The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. If there are rows in the "Customers" table that do not have matches in "Orders", these customers will NOT be listed. |