目录
问题:主表用,但是附表不存在,要求附表必须有如何校验?
SELECT
*
FROM
`gx_dd_pro_perfortargetbianone`
LEFT JOIN `gx_dd_pro_perfortarget_form_gmuj` ON gx_dd_pro_perfortargetbianone.id = gx_dd_pro_perfortarget_form_gmuj.masid
WHERE
gx_dd_pro_perfortargetbianone.id = 33
AND 1 = 1
AND gx_dd_pro_perfortarget_form_gmuj.STATUS = 1
AND gx_dd_pro_perfortargetbianone.STATUS = 1
AND ( LENGTH( gx_dd_pro_perfortarget_form_gmuj.primary_index ) = 0 ) is false
解析:
计算长度不能为零
设置条件:
( LENGTH( gx_dd_pro_perfortarget_form_gmuj.primary_index ) = 0 ) is true