(+)mysql中外部联接的语法 [英] (+) syntax for outer joins in mysql

问题描述

可能的重复项:
Oracle“(+)”运算符
Oracle(旧?)加入-用于转换的工具/脚本吗?

Possible Duplicates:
Oracle “(+)” Operator
Oracle (Old?) Joins - A tool/script for conversion?

使用Oracle多年以来一直让我有些受宠若惊.现在，我正在使用mysql，在MySQL中找不到外部连接的非ansi版本/简写版本.

I have been somewhat spoiled by using Oracle for years. Now I am using mysql and cannot find a non-ansi version/shorthand version of outer joins in MySQL.

在oracle中，我可以这样做

In oracle I could do this

select a.country acountry,
        a.stateProvince aStateProvince,
        b.countryName bcountry,
        b.name bstateProvince
  from User a,
          stateprovince b
  where a.country*=b.countryName **(+)**
          and a.stateProvince*=b.name **(+)**

获得外部联接. mysql可以做类似的事情吗?

to get an outer join. Can mysql do something similar?

推荐答案

比这个简单:

select a.country acountry,
        a.stateProvince aStateProvince,
        b.countryName bcountry,
        b.name bstateProvince
  from User a
        left join
          stateprovince b
    on  a.country = b.countryName 
          and a.stateProvince = b.name 

否.

这篇关于(+)mysql中外部联接的语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！