MySQL_LEFT JOIN......on......

最新推荐文章于 2024-07-09 10:41:03 发布

柳逸尘Cool

最新推荐文章于 2024-07-09 10:41:03 发布

阅读量193

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/hzj1369/article/details/82788529

版权

MySQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏


select 
    eki.dt_add as sdate,
    eki.dt_edit as edate,
    commontype.name as commontype_name,
    taskname.name as taskname_name,
    fs.name as fname,
    gems.name as gname,
    admin.name as gname1,
    kir.*
from erp_kj_icbc_result kir
    LEFT JOIN erp_kj_icbc eki on eki.id=kir.qryid
    LEFT JOIN assess_admin admin on admin.id=eki.mid_edit
    LEFT JOIN icbc_erp_commontype commontype on commontype.id=kir.type_id
    LEFT JOIN icbc_erp_commtaskname  taskname on taskname.`status`=kir.status
    LEFT JOIN assess_fs fs on eki.gems_fs_id=fs.id
    LEFT JOIN assess_gems gems on eki.gems_id=gems.id
where kir.icbc_id=#{icbc_id} and kir.type_id=#{type_id}
ORDER BY kir.dt_add asc