右连接 postgresql 出现语法错误

收到两个问题，第一个:

select SUBSTRING ("PriseNom",1,2) as "Chassis", "Date", "Time", sum("Puissance_W") as "Conso en W"
 from "vPe-Pdu"
 where SUBSTRING ("PriseNom",1,2) in ('0G','0H','0I','0J','0K','0L','0M','0N')
 group by 1,2,3
 order by "Date" desc ,"Time" desc, "Chassis" asc
 limit 8

输出Me 8行:

Chassis;Date;Time;Conso en W

0G;2023-08-25;11:00:01;871
0H;2023-08-25;11:00:01;1053
0I;2023-08-25;11:00:01;1147
0J;2023-08-25;11:00:01;1016
0K;2023-08-25;11:00:01;1618
0L;2023-08-25;11:00:01;1214
0M;2023-08-25;11:00:01;1666
0N;2023-08-25;11:00:01;1560

第二个给了我更多的代码行:

select SUBSTRING ("Chassis_Nom",1,2) as "Chassis", count(*) as "Nb Part"
 from "vPower-Lpars"
 where "Date" = (current_date - INTERVAL '1 day')::date
 group by 1;;

Chassis;Nb Part

0a;130
0L;3
0H;39
0J;20
0K;24
0I;39
0M;19
0b;178
0d;46
0G;17
0N;4
0f;49
0e;17

因此，我只想添加‘NB Part’列，以通过连接的方式使用

已try :

select SUBSTRING ("PriseNom",1,2) as "Chassis", "Date", "Time", sum("Puissance_W") as "Conso en W"
 from "vPe-Pdu"
 where SUBSTRING ("PriseNom",1,2) in ('0G','0H','0I','0J','0K','0L','0M','0N')
 group by 1,2,3
 order by "Date" desc ,"Time" desc, "Chassis" asc
 limit 8
LEFT JOIN
select SUBSTRING ("Chassis_Nom",1,2)  as "Chassis", count(*) as "Nb Part"
 from "vPower-Lpars"
 where "Date" = (current_date - INTERVAL '1 day')::date
 group by 1
USING ("Chassis")

但我有一个语法错误，我不知道如何避免(我判断了关键字之间的空格):

ERROR:  syntax error at or near "LEFT"
LINE 5: LEFT JOIN
        ^
SQL state: 42601
Character: 220

当然，我需要在第一个查询中保留我的订单和限额. 那么，我错过了什么？