select this_.QUERY_DT          as QUERY1_2_1_,     
       this_.LINK              as LINK2_1_,
       this_.YYYYMM            as YYYYMM2_1_,
       this_.YYYYWW            as YYYYWW2_1_,
       cal1_.QUERY_DT          as QUERY17_2_3_,     
       cal1_.QUERY_DT          as QUERY17_0_0_,       
       cal1_.SITE              as SITE0_0_,
       cal1_.TYPE              as TYPE0_0_,     
       cal1_.WORK_PCT          as WORK16_0_0_
  from TABLE_A this_
  left outer join (select * from TABLE_B ex where ex.site='PO' and ex.type='SITE') cal1_ on this_.query_dt = cal1_.query_dt
where this_.YYYYMM = 201107