要求:从本表中显示出parentid所对应的typename
select child.typename as parenttypename,parent.typename as typename,parent.parentid from questiontype as parent inner join questiontype as child on parent.parentId=child.ID order by parent.ID desc
效果
要求:从本表中显示出parentid所对应的typename
select child.typename as parenttypename,parent.typename as typename,parent.parentid from questiontype as parent inner join questiontype as child on parent.parentId=child.ID order by parent.ID desc
效果