4个表关联操作的sql语句怎么写？

两张表关联查询这样写就可以体现出多个列值组合并用逗号隔开
四张表应该怎么写这个sql语句呢？

SELECT
    a.*,
    group_concat( b.fcabin_cpbh )
FROM
    cd_car AS a
    LEFT JOIN cd_fcabin AS b ON find_in_set( b.fcabin_id, a.fcabin_id ) 
GROUP BY
    a.car_id

SELECT
    a.*,
    b.fcabin_cpbh,
    c.fair_cpbh,
    d.foil_cpbh 
FROM
    cd_car AS a
    INNER JOIN cd_fcabin AS b
    INNER JOIN cd_fair AS c
    INNER JOIN cd_foil AS d ON a.fcabin_id = b.fcabin_id 
    AND a.fair_id = c.fair_id
    AND a.foil_id = d.foil_id

如果这样写的话，fcabin_cpbh就只有一个值了

cd_car表

cd_fcabin 表

cd_fair 表

cd_foil 表

最终想实现效果如下
请教 group_concat( ) 和 find_in_set( ) 一起用，4个表关联怎么写

用子表连接查询。

SELECT group_concat( e.fcabin_cpbh ) from
(SELECT
    a.*,
    b.fcabin_cpbh,
    c.fair_cpbh,
    d.foil_cpbh 
FROM
    cd_car AS a
    INNER JOIN cd_fcabin AS b
    INNER JOIN cd_fair AS c
    INNER JOIN cd_foil AS d ON a.fcabin_id = b.fcabin_id 
    AND a.fair_id = c.fair_id
    AND a.foil_id = d.foil_id)  e

感觉你的cd_car表里的字段写的有问题，fair_id这就不是数字类型了，你链接应该会出现各种bug，你应该将他们分开写，查询的时候可以进行合并，通过使用组函数里的collect_list将指定字段合并成为一个数组，前提是除了这个字段，其他字段对应的值都一样