select * from
(
select * from tb1
)
left join
(
select * from tb2
)
where .....
------解决方案--------------------
- SQL code
select * from tbl a left join tb2 b on a.col=b.colwhere ......
------解决方案--------------------
select * from tb1
left join tb2 on ....
where .....
------解决方案--------------------
select *
from tb1
left join tb2 on ...
where ...