right
英[raɪt] 美[raɪt]
adv.immediately, immediately; to the right, right; appropriately; always
adj. Correct; appropriate; right; good, normal
n. right; right; correct, just; right hand
vt. correct; straighten, make it right ; Arrangement; compensation
vi. (ships, etc.) to be restored to stability
Third person singular: rights Plural: rights Present participle: righting Past tense: righted Past participle: righted
join
UK[dʒɔɪn] US[dʒɔɪn]
vt.& vi.Join;participate;connect;connect
vt. Participate; combine; get on (train, plane, etc.); get on (road)
n.Connect; combine; join; join point
Third person singular: joins Present participle: joining Past tense : joined past participle: joined
mysql RIGHT JOIN keyword syntax
Function:The RIGHT JOIN keyword will return all rows in the right table (table_name2), even if there are no matching rows in the left table (table_name1).
Syntax:SELECT column_name(s) FROM table_name1 RIGHT JOIN table_name2 ON table_name1.column_name=table_name2.column_name
Comments:In some databases , RIGHT JOIN is called RIGHT OUTER JOIN.
mysql RIGHT JOIN keyword example
//列出所有的定单，以及定购它们的人 - 如果有的话 SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons RIGHT JOIN Orders ON Persons.Id_P=Orders.Id_P ORDER BY Persons.LastName;