数据库

1. Join：Return rows that at least there is one match in both tables.

　　left join: return all rows from the left table, even if there is no match in right table.

　　ritht join: return all row from the right table, even if there is no match in left table.