SELECT distinct * from t_fagroup where fid<>0 order by fnumber
SELECT * FROM t_FALocation WHERE FID <> 0 ORDER BY FNumber
SELECT distinct * from t_fagroup where fid<>0 order by fnumber
SELECT * FROM t_FALocation WHERE FID <> 0 ORDER BY FNumber