SQL语句:如果将“IN”改成“JOIN”的形式?SQL语句如下,如果改成JOIN的形式?SELECT
*
FROM
SpecialWord
WHERE
CategoryID NOT IN
( SELECT
f_field_category_id
FROM
t_im_field_mas
WHERE
f_field_customer_id = 'WYB00002' AND
f_field_form_id ='0002'
)
*
FROM
SpecialWord
WHERE
CategoryID NOT IN
( SELECT
f_field_category_id
FROM
t_im_field_mas
WHERE
f_field_customer_id = 'WYB00002' AND
f_field_form_id ='0002'
)
a.*
FROM
SpecialWord a
WHERE
not exists(SELECT
1
FROM
t_im_field_mas
WHERE
a.CategoryID=f_field_category_id
and
f_field_customer_id = 'WYB00002'
and
f_field_form_id ='0002')
WHERE not exists (SELECT 1 FROM t_im_field_mas WHERE CategoryID=f_field_category_id and f_field_customer_id = 'WYB00002' AND f_field_form_id ='0002')
from syepcialword a left join t_im_field_mas b
on a.CategoryID=b.f_field_category_id
and b.f_field_customer_id='WYB00002'
and b.f_field_form_id ='0002'
where b.f_field_category_id is null
SELECT
a.*
FROM
SpecialWord a
inner join
( SELECT
f_field_category_id
FROM
t_im_field_mas
WHERE
f_field_customer_id = 'WYB00002' AND
f_field_form_id ='0002'
) b
on a.CategoryID=b.f_field_category_id
LEFT OUTER JOIN t_im_field_mas b ON
a.CategoryID = b.f_field_category_id AND
b.f_field_customer_id = 'WYB00002' AND
b.f_field_form_id ='0002'