JOIN,INSERT句法.docxVIP

JOIN句法MySQL支持下列用于SELECT语句的JOIN句法：table_reference, table_referencetable_reference [CROSS] JOIN table_referencetable_reference INNER JOIN table_referencetable_reference STRAIGHT_JOIN table_referencetable_reference LEFT [OUTER] JOIN table_reference ON conditional_exprtable_reference LEFT [OUTER] JOIN table_reference USING (column_list)table_reference NATURAL LEFT [OUTER] JOIN table_reference{ ojtable_reference LEFT OUTER JOIN table_reference ON conditional_expr }上述最后的LEFT OUTER JOIN的句法只是为了与ODBC兼容而存在的。一个表可以是使用aliasedtbl_name AS alias_name或tbl_namealias_name的起的别名。mysql select t1.name, t2.salary fro