select distinct f1.airway_point_name,f1.latitude,f1.longitude,upper(f1.airway_point_type_name)type,f2.code_fir from airway_ordered_point f1, v_airway_point f2
where f2.significant_point_id=f1.airway_point_idorder by code_fir, type,airway_point_name本文共 300 字，大约阅读时间需要 1 分钟。
select distinct f1.airway_point_name,f1.latitude,f1.longitude,upper(f1.airway_point_type_name)type,f2.code_fir from airway_ordered_point f1, v_airway_point f2
where f2.significant_point_id=f1.airway_point_idorder by code_fir, type,airway_point_name转载于:https://www.cnblogs.com/mol1995/p/6971874.html