mysql INNER JOIN keyword

inner

英[ˈɪnə(r)] 美[ˈɪnɚ]

adj. Internal, inner; spiritual; secret

n.Inside, inside; a shot that hits the part close to the bullseye

Plural: inners

join

英[dʒɔɪn] 美[ 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 INNER JOIN keyword syntax

Function: The INNER JOIN keyword returns rows when there is at least one match in the table.

Syntax: SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name

Comments: INNER JOIN and JOIN Are the same.

mysql INNER 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;