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'