mysql JOIN keyword

UK[dʒɔɪn] US[dʒɔɪn]

vt.& vi.Join; participate; connect; connect

vt.Participate; combine; get on (train, plane, etc.); get on (Road)

n. connection; combination; joint; joint point

Third person singular: joins Present participle: joining Past tense: joined Past participle: joined

mysql JOIN keyword syntax

Function:Used to query data from two or more tables based on the relationship between columns in these tables.

Description:Tables in the database can be linked to each other through keys. The primary key (Primary Key) is a column in which the value of each row is unique. In a table, each primary key value is unique. The purpose of this is to cross-bundle data between tables without duplicating all the data in each table.

mysql JOIN keyword example

//列出所有人的定购 SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons INNER JOIN Orders ON Persons.Id_P = Orders.Id_P ORDER BY Persons.LastName;