select sum(SP_PURCHASE_PRICE) FROM sys_supplies WHERE sys_supplies.id in
(select SP_SUPPLIER_ID from sys_supplier WHERE sys_supplies.SP_SUPPLIER_ID=sys_supplier.ID) or sys_supplies.id in
(select SP_ID from sys_order_item where sys_order_item.OD_ID in
(select sys_order.ID from sys_order where sys_order.OD_CREATETIME BETWEEN '2019-01-25 17:41:51' and '2019-01-27 19:30:35'))
备注: or 等于 并集 【U】