求Oracle查询语句

Question

有一张表GA_CC_BDR，结构如下
  o_prov_id int
  d_prov_id int
  o_city_id int
  d_city_id int有另外一张表ZcCityInfo，结构如下
  prov_id int
  city_id int
  prov_Name varchar
  city_Name varchar其中表GA_CC_BDR中的o_prov_id，d_prov_id对应ZcCityInfo中的prov_id
    表GA_CC_BDR中的o_city_id，d_city_id对应ZcCityInfo中的city_id我想查询表GA_CC_BDR中
  o_prov_id对应的prov_Name
  d_prov_id对应的prov_Name
  o_city_id对应的city_Name
  d_city_id对应的city_Name
并一起显示出来
  
  

Answer 1

select  a.o_prov_id ,b.prov_Name o_prov_Name, a.o_city_id ,c.city_Name o_city_Name,
        a.d_prov_id ,c.prov_Name d_prov_Name, a.d_city_id ,c.city_Name d_city_Name,
  from GA_CC_BDR a,ZcCityInfo b,ZcCityInfo c
where a.o_prov_id =b.prov_id and a.o_city_id =b.city_id 
  and a.d_prov_id =c.prov_id and a.d_city_id =c.city_id 

Answer 2

select a.o_prov_id ,b.prov_Name o_prov_Name, a.o_city_id ,c.city_Name o_city_Name,
  a.d_prov_id ,c.prov_Name d_prov_Name, a.d_city_id ,c.city_Name d_city_Name,
  from GA_CC_BDR a,ZcCityInfo b,ZcCityInfo c
where a.o_prov_id =b.prov_id and a.o_city_id =b.city_id  
  and a.d_prov_id =c.prov_id and a.d_city_id =c.city_id 

Answer 3

select a.o_prov_id ,b.prov_Name o_prov_Name, a.o_city_id ,c.city_Name o_city_Name,
  a.d_prov_id ,c.prov_Name d_prov_Name, a.d_city_id ,c.city_Name d_city_Name,
  from GA_CC_BDR a,ZcCityInfo b,ZcCityInfo c
where a.o_prov_id =b.prov_id and a.o_city_id =b.city_id   
  and a.d_prov_id =c.prov_id and a.d_city_id =c.city_id 

Answer 4

SELECT O_PROV_ID,
       (SELECT PROV_NAME FROM ZCCITYINFO WHERE PROV_ID = T.O_PROV_ID) O_PROV_NAME,
       D_PROV_ID,
       (SELECT PROV_NAME FROM ZCCITYINFO WHERE PROV_ID = T.D_PROV_ID) D_PROV_NAME,
       O_CITY_ID,
       (SELECT CITY_NAME FROM ZCCITYINFO WHERE CITY_ID = T.O_CITY_ID) O_CITY_NAME,
       D_CITY_ID,
       (SELECT CITY_NAME FROM ZCCITYINFO WHERE CITY_ID = T.D_CITY_ID) D_CITY_NAME
  FROM GA_CC_BDR T;