立即学习:https://edu.csdn.net/course/play/27328/370702?utm_source=blogtoedu
自连接:SELECT a.id ,a.name,b.name as aNmae
from aa a,aa b
where a.pid = b.id and a.pid<>0;
同一张表
立即学习:https://edu.csdn.net/course/play/27328/370702?utm_source=blogtoedu
自连接:SELECT a.id ,a.name,b.name as aNmae
from aa a,aa b
where a.pid = b.id and a.pid<>0;
同一张表