连接

1.内连接

select name,language from country language,country

where countrycode=code;

select name,language from countryLanguage,country where countryCode=code and language='Swedish';

12.2.2 写内连接使用INNER JOIN

from contryLanguage inner join Country on CountryCode=code;

如果两个表的列名相同

可以这样写 from countryLanguage inner join country using (code);

12.3 写外连接

为了write a  join that provides information about mismatches or missing records,use an outer join.

LEFT JOIN 或者RIGHT JOIN关键字而不是分隔符或者INNER JOIN关键