这个用并和查询用该怎么搞

Question

select i.id,c.customer,i.invoice_num from crm_invoice i left join crm_customer c on i.customer_id=c.id  unionall select p.params_name from param_sysparam p left join crm_order o on o.pay_type_id = p.id;

报错

select p.params_name from param_sysparam p left join crm_order o on o.pay_type_id = p.id;

单独执行就不应该怎么写

Answer 1

用union替换unionall试下