27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT ClassCodeId,
ClassCode
FROM table1 t1
WHERE EXISTS (SELECT *
FROM table1 t2
WHERE t2.TypeName = t1.ClassCodeId
)
select b.id,a.classCodeId,a.classcodeName,b.TypeName from tabele1 a inner join tabele1 b
on a.classCodeId=b.TypeName
由于你的要求不详,只写到这一步