Simplify join with join using in SQL

This article comes from a joined SQL statement in Http://blog.csdn.net/wjc19911118/article/details/9716391Mysql, with the syntax format of the ON clause: Table1.column_name = Table2.column_name. When schema design uses the same naming style for columns that join tables, you can use the using syntax to simplify the on syntax, in the form: using (column_name). For example: [SQL]View PlainCopy

1. [SQL]
2. SELECT F.color, C.is_primary, C.is_dark, C.is_rainbow
3. From Flags F www.2cto.com
4. INNER JOIN color c on f.color = C.color
5. WHERE f.country = ' China ';

Equivalent to [SQL]View PlainCopy

1. [SQL]
2. SELECT F.color, C.is_primary, C.is_dark, C.is_rainbow
3. From Flags F
4. INNER JOIN color C USING (color)
5. WHERE f.country = ' China ';

Simplify join with join using in SQL