join具体用法（Join specific usage）.docVIP

join具体用法（Join specific usage） SQL JOIN data base Sometimes in order to get the full result, we need to get results from two or more tables. We need to implement join. Tables in a database can link each other by key. A primary key (Primary Key) is a column in which the values of each row are unique. In a table, the value of each primary key is unique. The purpose of this is to cross data between tables without having to repeat all the data in each table. Employee_ID will separate everyone, even if all of them share the same name. When you see the following example, please pay attention to the following points: The Employee_ID column is the primary key of the Employees table The Prod_ID column is the primary key of the Orders table The Employee_ID column in the Orders table is used to refer to employees in the Employees table without using their exact names Table Employees: Employee_ID Name 01 Adams, John 02 Bush, George 03 Carter, Thomas 04 Gates, Bill Table Orders: Prod_ID Product Employee_ID 234 Printer 01 657 Table 03 865 Chair 03 Refer to two tables We can obtain data from two tables by referencing two tables: Example Who ordered the products and what products did they order? SELECT, Employees.Name, Orders.Product, FROM, Employees, Orders, WHERE, Employees.Employee_ID = Orders.Employee_ID Results: Name Product Adams, John, Printer Carter, Thomas, Table Carter, Thomas, Chair Example Who ordered the printer? SELECT, Employees.Name, FROM, Employees, Orders, WHERE, Employees.Employee_ID = Orders.Employee_IDAND, Orders.Product =Printer Results: Name Adams, John Using Join We can also use keyword JOIN to obtain data from two tables: JOIN (INNER) Syntax: SELECT field 1, field 2, field 3FROM, first table INNER JOIN, second table ON, first table.Keyfield = second table.Foreign_keyfield Example Who ordered the products and what did they order? SELECT, Employees.Name, Orders.Product, FROM, Employees, INNER, JOIN, Employees.Employee_ID=Orders.Employee_ID, Orders, ON The inne