OR条件怎么使用IN子查询


目标sql是

SELECT
`fld_ID` AS `id`,
`fld_name` AS `name`
FROM
`channels`
WHERE
(`fld_status` = 1)
AND (
`fld_parent` = 3
OR `fld_parent` IN (
SELECT
`fld_ID`
FROM
`channel_class`
WHERE
(`fld_parent` = 3)
)
)

怎么使用构建器啊,其中两表fld_parent值是变量?拼不出来了,求助


点赞 取消点赞 收藏 取消收藏

<< 上一篇: laravel 5.7版本,模板布局中公共模板的变量怎么传值

>> 下一篇: 谁做过人脸检测?