select a.i_spare_part_type_id,
b.s_spare_part_code,
b.s_spare_part_name,
a.i_num
from (select t.i_spare_part_type_id, count(t.i_log_id) as i_num
from t_stocktaking_plan_log t
group by t.i_spare_part_type_id) a
left join t_wh_cell_part b
on a.i_spare_part_type_id = b.i_spare_part_type_id
假如非黑色字体部分的代码存在语法错误,那么pl/sql的检验报错顺序为:红,绿,蓝。即sql的语法检查并非从左到右、从头到尾。