表名:test
表字段: id ,name ,pid
SQL语句:
SELECT t1.*,t2.name AS province FROM test t1 INNER JOIN test AS t2 ON
t1.pid=t2.id.
执行后:
当然还可以继续一直关联下去,也可以实现无限级分类,后面自行引申。
某一个字段相同,但是type不同的count数量需要横向展示
select * from
(SELECT * FROMapp_log_record
where type =1 ) as A
LEFT JOIN
(SELECT * FROMapp_log_record
where type =5 ) as E
on A.webcf_id = E.webcf_id
查询结果