mysql左连接能否用三个表_左连接在同一个表上，分析趋势mysql

表结构如下

+---------------+---------+---------+

| customer_name | date | balance |

+---------------+---------+---------+

| 123 | june 14 | 20 |

| 123 | june 15 | 30 |

| 1234 | june 14 | 30 |

| 12345 | june 16 | 50 |

+---------------+---------+---------+我想加入同一张桌子，将原始数据保留为2014年，我想分析趋势，看看哪些客户的平衡值不会从2014年开始变化。

例如我想展示下面

+-----------+-----------+-----------+

| custmomer | june14bal | june15bal |

+-----------+-----------+-----------+

| 1234 | 30 | null |

| 123 | 20 | 30 |

+-----------+-----------+-----------+我有三个左连接，但似乎无法正常工作。最重要的是从2014年起开始使用记录样本。

当前脚本

with TABLE_DATA as

(

select Customer ,DATE, Balance

from table

where dATE in ('30-JUN-2014','30-juN-2015')

)

SELECT

sum(inv1.balance) as year1bal,

suminv2.balance) as year2bal,

customer,

date

from table_datA inv1

left join TABLE_DATA inv2

on inv1.customer= inv2.customer and inv2.as_of_Date = '30-June-2015'

group by date, customer