摘要： ASSESS_FINAL_RESULT表有supplierId，是supplier表的外键两张表都有deleted字段，表示是否已经被删除。如下两条语句：select * from supplier s left join ASSESS_FINAL_RESULT afr on afr.supplier_id = s.supplier_id and afr.deleted = 0 where s.deleted = 0------------------- select * from supplier s left join ASSESS_FINAL_RESULT afr ... 阅读全文