sql 20170906 left join

最新推荐文章于 2024-07-23 23:39:10 发布

spencer_tseng

最新推荐文章于 2024-07-23 23:39:10 发布

阅读量190

点赞数

CC 4.0 BY-SA版权

分类专栏： database

本文链接：https://blog.youkuaiyun.com/spencer_tseng/article/details/77865636

database 专栏收录该内容

45 篇文章

订阅专栏

本文介绍了一种SQL查询方法，用于从批量表单批次中提取相关信息，包括批次ID、名称及关联表单的详细信息等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT 
    b.id AS bid, 
    b.NAME AS bName,
    f.id AS fId,
    f.NAME AS fName,
    f.tableName AS fTableName, 
    f.pid AS fPid
FROM t_fb_fill_in_batch b
    LEFT JOIN t_fb_batch_form bf ON b.id = bf.batch_id
    LEFT JOIN t_fb_form f ON bf.form_id = f.id
WHERE 1 = 1 
    AND b.id = 'c258f48cd30f47808f3ce1a32d86b218'