Search This Blog

Friday, September 9, 2016

SQL - Thêm dòng

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