SELECTCOUNT(*) FROM((SELECT id,money,createtime,status FROM pre_pay_log WHERE memb_id = 51225) UNIONALL (SELECT id,money,createtime,status FROM pre_cash_log WHERE memb_id = 51225))
此句查询会报错:Every derived table must have its own alias//每个派生出来的表都必须要有自己的别名
SELECTCOUNT(*) FROM((SELECT id,money,createtime,status FROM pre_pay_log WHERE memb_id = 51225) UNIONALL (SELECT id,money,createtime,status FROM pre_cash_log WHERE memb_id = 51225)) as a
SELECT * FROM((SELECT id,money,createtime,status,error AS form_account,payment_no AS type_name FROM pre_pay_log WHERE 1 AND memb_id =51225) UNIONALL (SELECT id,money,createtime,status,form_account,type_name FROM pre_cash_log WHERE 1 AND memb_id =51225)) as a ORDERBY a.id DESC LIMIT 0,20