select t1.c1,t2.c2 from (
(select IFNULL(SUM(total_price),0) c1
from database1.table1 where order_status=0) t1,
(select count(*) c2
from database1.table1 where order_status=2) t2
)
image
select t1.c1,t2.c2 from (
(select IFNULL(SUM(total_price),0) c1
from database1.table1 where order_status=0) t1,
(select count(*) c2
from database1.table1 where order_status=2) t2
)
本文标题：SimpleSql
本文链接：https://www.haomeiwen.com/subject/tiaeuftx.html
网友评论