SELECT DISTINCT c.gnmkbh AS gnmkbh, c.cdxsmc AS cdxsmc, c.dywj AS dywj, c.cdzbh AS cdzbh,d.* FROM ( SELECT * FROM (SELECT qxlb FROM QX_zw WHERE ','+''+',' LIKE '%,' + cast(zwbh AS varchar) + ',%')a INNER JOIN (SELECT gnmkbh, cdxsmc, dywj, cdzbh FROM oa_qx_ktgnmklb where qxbz<>'X')b ON ',' + CAST(a.qxlb AS varchar(8000)) + ',' LIKE '%,' + b.GNMKBH + ',%' )c INNER JOIN (SELECT name, number, sybz FROM oa_qx_menumaster WHERE sybz <>'X')d
SELECT DISTINCT c.gnmkbh AS gnmkbh, c.cdxsmc AS cdxsmc, c.dywj AS dywj, c.cdzbh AS cdzbh,d.* FROM ( SELECT * FROM (SELECT qxlb FROM QX_zw WHERE ','+''+',' LIKE '%,' + cast(zwbh AS varchar) + ',%')a INNER JOIN (SELECT gnmkbh, cdxsmc, dywj, cdzbh FROM oa_qx_ktgnmklb where qxbz<>'X')b ON ',' + CAST(a.qxlb AS varchar(8000)) + ',' LIKE '%,' + b.GNMKBH + ',%' )c INNER JOIN (SELECT name, number, sybz FROM oa_qx_menumaster WHERE sybz <>'X')d
ON c.cdzbh = d.number order by c.cdzbh
SELECT qxlb FROM QX_zw WHERE ','+''+',' LIKE '%,' + cast(zwbh AS varchar) + ',%'这句的LIKE前后顺序确定没错?
DISTINCT 关键字可从 SELECT 语句的结果中除去重复的行,这是对的SQL语句是放到查询分析器里面是可以执行的.只是我这句话罗里罗嗦我看不懂.
DISTINCT c.gnmkbh AS gnmkbh, c.cdxsmc AS cdxsmc, c.dywj AS dywj, c.cdzbh AS cdzbh,d.* FROM
(
SELECT * FROM
(SELECT qxlb FROM QX_zw WHERE ','+''+',' LIKE '%,' + cast(zwbh AS varchar) + ',%')a
INNER JOIN
(SELECT gnmkbh, cdxsmc, dywj, cdzbh FROM oa_qx_ktgnmklb where qxbz<>'X')b
ON ',' + CAST(a.qxlb AS varchar(8000)) + ',' LIKE '%,' + b.GNMKBH + ',%'
)c INNER JOIN
(SELECT name, number, sybz FROM oa_qx_menumaster WHERE sybz <>'X')d
ON c.cdzbh = d.number order by c.cdzbh
---------
distinct 那么多列,还会有重复的吗?
DISTINCT c.gnmkbh AS gnmkbh, c.cdxsmc AS cdxsmc, c.dywj AS dywj, c.cdzbh AS cdzbh,d.* FROM
(
SELECT * FROM
(SELECT qxlb FROM QX_zw WHERE ','+''+',' LIKE '%,' + cast(zwbh AS varchar) + ',%')a
INNER JOIN
(SELECT gnmkbh, cdxsmc, dywj, cdzbh FROM oa_qx_ktgnmklb where qxbz<>'X')b
ON ',' + CAST(a.qxlb AS varchar(8000)) + ',' LIKE '%,' + b.GNMKBH + ',%'
)c INNER JOIN
(SELECT name, number, sybz FROM oa_qx_menumaster WHERE sybz <>'X')d
ON c.cdzbh = d.number order by c.cdzbh