如何把量表的列拼在一起

Question

我从两个表里面分别查询出了一条记录，如何将两个表查出的记录的列拼接并返回，行数是相同的只有一行， sql 是下面这个 SQL codeselect sum(totalprice) as selltotal,sum(writeprice) as sellwrite
from selllist_tb 
select  sum(goodcost) as goodcost,sum(shoucost) as shoucost,sum(flowercost) as flowercost,sum(writecost) as writecost 
from flowersell_tb

Answer 1

select 
  selltotal = (select sum(totalprice) from selllist_tb ),
  sellwrite = (select sum(writeprice) from selllist_tb ),
  goodcost = (select sum(goodcost) from flowersell_tb ),
  shoucost = (select sum(shoucost) from flowersell_tb ),
  flowercost = (select sum(flowercost) from flowersell_tb ),
  writecost = (select sum(writecost) from flowersell_tb )