select n from( select 客户名称,1 as k,客户名称 as n from 数据表 union all select 客户名称,2 as k,商品名称 from 数据表 ) t order by 客户名称,k
假设格式固定: SELECT `客户名称` FROM ( SELECT DISTINCT A.`客户名称`,RIGHT(A.`客户名称`,1) AS BZ FROM QBB A UNION ALL SELECT A.`商品名称`,RIGHT(A.`客户名称`,1) AS BZ FROM QBB A ) B ORDER BY BZ
select 客户名称,1 as k,客户名称 as n from 数据表
union all
select 客户名称,2 as k,商品名称 from 数据表
) t
order by 客户名称,k
SELECT `客户名称` FROM (
SELECT DISTINCT A.`客户名称`,RIGHT(A.`客户名称`,1) AS BZ FROM QBB A
UNION ALL
SELECT A.`商品名称`,RIGHT(A.`客户名称`,1) AS BZ FROM QBB A ) B
ORDER BY BZ