如何将这2条语句整合为1条，并将结果在一个表内显示出来？

suvin

sql命令不熟悉，请大家帮帮忙



select op, sum(ipri) as 含税进库成本, sum(spri) as 含税进库销售金额 from ab where (gyfk like \'a%\' or gyfk like \'c%\')

select op, sum(ipri) as 不含税进库成本, sum(spri) as 不含税进库销售金额 from ab where gyfk like \'b%\' group by op order by op

tianyety

select op,

sum(case when gyfk like \'a%\' then ipri else 0 end ) as 含税进库成本,

sum(case when gyfk like \'a%\' then spri else 0 end ) as 含税进库销售金额,

sum(case when gyfk like c%\' then ipri else 0 end ) as 含税进库成本,

sum(case when gyfk like \'c%\' then spri else 0 end ) as 含税进库销售金额,

sum(case when gyfk like b%\' then ipri else 0 end ) as 不含税进库成本,

sum(case when gyfk like \'b%\' then spri else 0 end ) as 不含税进库销售金额

group by op order by op

majindi0823

select op,含税进库成本,含税进库销售金额,不含税进库成本,不含税进库销售金额

from (

select op, sum(ipri) as 含税进库成本, sum(spri) as 含税进库销售金额 from ab where (gyfk like \'a%\' or gyfk like \'c%\') ) t1,(

select op, sum(ipri) as 不含税进库成本, sum(spri) as 不含税进库销售金额 from ab where gyfk like \'b%\' group by op order by op) t2

where t1.op=t2.op

我的无助

受教了，谢谢。