急救一段SQL的转换,本人不胜感激......
有一段MSSQL下的SQL语句需要转换成ORACLE下能执行的语句
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 admin_QX_ZW WHERE ','+'1'+',' LIKE '%,' + cast(zwbh AS varchar) + ',%') a INNER JOIN (SELECT gnmkbh, cdxsmc, dywj, cdzbh FROM admin_QX_KTGNMKLB where qxbz<>'X') b ON ',' + CAST(a.qxlb AS varchar(8000)) + ',' LIKE '%,' + b.GNMKBH + ',%') c INNER JOIN (SELECT name, nnumber, sybz FROM admin_QX_MENUMASTER WHERE sybz <>'X') d ON c.cdzbh = d.nnumber order by c.cdzbh
还请帮忙,本人不胜感激,另开贴给分.