mysql FULL JOIN keyword

full

English [fʊl] American [fʊl]

adj. Full, filled; complete, complete; rich; detailed

adv. Extremely, extremely; fully, completely; completely; directly

n.entirely; completely; fully, completely; at its peak

v. Sewing clothes to make them wider; sewing pleats into skirts; [printing] steaming, rinsing

Comparative: fuller Superlative: fullest

join

英[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 FULL JOIN keyword syntax

Function: As long as there is a match in one of the tables, the FULL JOIN keyword will return rows.

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

Comments: In some databases , FULL JOIN is called FULL OUTER JOIN.

mysql FULL JOIN keyword example

//列出所有的人，以及他们的定单，以及所有的定单，以及定购它们的人
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons FULL JOIN Orders ON Persons.Id_P=Orders.Id_P ORDER BY Persons.LastName;