求大神给帮帮忙
“SELECT a."FLIGHT_DATE",
a."FLIGHT_NO",
a."AC_REG",
a."AC_TYPE",
a.ARRIVAL_AIRPORT,
a.STD,
a.ETD,
a.DEPARTURE_AIRPORT,
a."FLIGHT_ID",
a."CREW_LINK_LINE",
(select count(1) from t9001 where t9001.flight_id = a."FLIGHT_ID") is_send,
'' route,
'' route_name,
0 p_count,
b.crew_s_num,
b.crew_a_weight
FROM "T2001" a, "T4007" b
WHERE a.ac_type=b.ac_type_short and
(a.flg_cs is null) and
(nvl(trunc(a.etd),trunc(a.flight_date)) = to_date(:as_date,'yyyy-mm-dd' ))
”这个程序我已经改过可是在程序运行时还是会出现指定的route 列在某种条件下显示不出来 求大神给答案。。。