sql 20170906 left join

来源:互联网 发布:淘宝男装夏季 编辑:程序博客网 时间:2024/06/06 05:15



SELECT     b.id AS bid,     b.NAME AS bName,    f.id AS fId,    f.NAME AS fName,    f.tableName AS fTableName,     f.pid AS fPidFROM 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.idWHERE 1 = 1     AND b.id = 'c258f48cd30f47808f3ce1a32d86b218'


原创粉丝点击