lzykevin
4/28/2020 - 9:17 AM

FDL深南航共飞航线 #zhusanjiao

FDL深南航共飞航线 #zhusanjiao

--深南航共飞航线
SELECT DISTINCT eline
FROM dcdb.v_tb_inport_detail t
WHERE dep_date BETWEEN '2020-04-01' AND '2020-04-30'
  AND t.air_code IN ('ZH')
  AND t.eline LIKE 'SZX%'
  AND t.up_location IN ('SZX')
  AND substr(t.flight_no, -1) BETWEEN '0' AND '9'

INTERSECT
SELECT DISTINCT eline
FROM dcdb.v_tb_inport_detail t
WHERE dep_date BETWEEN '2020-04-01' AND '2020-04-30'
  AND t.air_code IN ('CZ')
  AND t.eline LIKE 'SZX%'
  AND t.up_location IN ('SZX')
  AND substr(t.flight_no, -1) BETWEEN '0' AND '9'