试试这个:
SELECT A.名称,B.名称 FROM
(SELECT 类别,上级类,名称 FROM TABLE_NAME WHERE 上级类<>'0' ) A,
(SELECT 类别,名称 FROM TABLE_NAME WHERE 上级类='0' ) B
WHERE A.上级类 = B.类别
SELECT A.名称,B.名称 FROM
(SELECT 类别,上级类,名称 FROM TABLE_NAME WHERE 上级类<>'0' ) A,
(SELECT 类别,名称 FROM TABLE_NAME WHERE 上级类='0' ) B
WHERE A.上级类 = B.类别
(SELECT 类别,上级类,名称 FROM TABLE_NAME WHERE 上级类<>'0' ) A,
(SELECT 类别,名称 FROM TABLE_NAME WHERE 上级类='0' ) B
WHERE A.上级类 = B.类别
这个可以的