select * from a left join b on a.abid = b.baid left join c on c.cbid = b.bcid
把括号里面当成一个表的数据, 注意一定要别名 后面的a 就是这表的别名
select * from (select * form kk where id=2) a where type=2
select * from a left join b on a.abid = b.baid left join c on c.cbid = b.bcid
把括号里面当成一个表的数据, 注意一定要别名 后面的a 就是这表的别名
select * from (select * form kk where id=2) a where type=2