主表先查询连接子表时间查询
<br />select<br /> BP.*,<br /> BBSI.LastBTime<br />from <br /> (<br /> select<br /> P.* <br /> from BBSPlate P <br /> where 1=1 and P.plateName like '%2%'<br /> ) AS BP<br /> left join <br /> (<br /> select <br /> BI.bType,<br /> MAX
原创
2010-12-25 13:32:00 ·
347 阅读 ·
0 评论