select 'N' as SalesRouteID, 'A NONE' as Descr
union all
select 'W' as SalesRouteID, 'ALL' as Descr
union all
SELECT distinct r.SalesRouteID, r.Descr
FROM OM_SalesRouteDet a
INNER JOIN OM_SalesRoute r on a.SalesRouteID = r.SalesRouteID ORDER BY Descr

No comments:
Post a Comment