统计多个表的记录到一个专门的结果表中

需求，统计多个表的记录到一个专门的结果表中

室友教的新写法，cda大佬救命了
没学过的暂且记录一下，后续得补充一下dual表的知识

select 
	(select count(id) as datasetnum  from c2_bdg_ds_his_dataset c1) as x1,
	(select count(id) as datasetitemnum from c2_bdg_ds_his_dataset_item c2) x2
from dual;