mysql 多查询临时表的运用 

SELECT * from (select count(*) imgCount1 from imagetable where SeriesID = '120106199202063029201809291007TMI0222001') i,
   (select ImageCount imgCount2 from seriestable where SeriesID = '120106199202063029201809291007TMI0222001') s

 

posted @ 2018-09-29 11:55  风影我爱罗  阅读(1654)  评论(0)  编辑  收藏  举报