mysql view 子查询_mysql – View的SELECT包含FROM子句中的子查询

我有两个表,我需要创建一个视图.表格是：

credit_orders(id, client_id, number_of_credits, payment_status)

credit_usage(id, client_id, credits_used, date)

我使用以下查询来执行此操作.没有“创建视图”部分的查询运行良好,但使用“创建视图”时,它显示错误“视图的SELECT包含FROM子句中的子查询”.可能是什么问题&解决方案：

create view view_credit_status as

(select credit_orders.client_id,

sum(credit_orders.number_of_credits) as purchased,

ifnull(t1.credits_used,0) as used

from credit_orders

left outer join (select * from (select credit_usage.client_id,

sum(credits_used) as credits_used

from credit_usage

group by credit_usage.client_id) as t0

) as t1 on t1.client_id = credit_orders.client_id

where credit_orders.payment_status='Paid'

group by credit_orders.client_id)