我认为你只是错过了一个投标的加入条件，对选定的供应商过滤。允许没有供应商的作业同时逐出其供应商未被客户选择的作业的逻辑有点棘手，并且在 WHERE 条款：

SELECT ...
FROM job
INNER JOIN customer 
      ON customer.id = job.cId 
LEFT JOIN supplier 
      ON supplier.id = job.sId
LEFT JOIN bid 
     ON  bid.sId = job.sId 
     AND bid.jId = job.id   --> here
WHERE supplier.id IS NULL OR bid.id IS NOT NULL

在select语句中，尝试从bid表中检索数据 bid.value 但你没有加入那张table。

select j.id,
       j.title,
       j.desc,
       j.mobile,
       j.address,
       j.city,
       j.updatedAt,
       j.status,
       b.value,
       c.cName,
       s.sName
from job as j
         inner join customer as c
                    on j.cId = c.id
         inner join supplier as s
                    on j.sId = s.id
         inner join bid as b
                    on j.id = b.jId;