SELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE (qiyedm NOT IN (SELECT jgdm FROM dbo.Jgdm WHERE (jgdm IS NOT NULL))) UNION ALLSELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE (qiyedm IS NULL)
FROM dbo.Mpcx
WHERE (qiyedm NOT IN (SELECT jgdm FROM dbo.Jgdm WHERE (jgdm IS NOT NULL))) UNION ALLSELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE (qiyedm IS NULL)
WHERE (qiyedm NOT IN (SELECT distinct jgdm FROM dbo.Jgdm where jgdm is not null)) OR (qiyedm IS NULL)
SELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE (qiyedm NOT IN
(SELECT jgdm
FROM dbo.Jgdm
WHERE (jgdm IS NOT NULL)))SELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx AS a
WHERE (NOT EXISTS
(SELECT jgdm
FROM dbo.Jgdm AS b
WHERE (a.qiyedm = jgdm)))
SELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE (qiyedm NOT IN
(SELECT jgdm
FROM dbo.Jgdm
WHERE (jgdm IS NOT NULL)))SELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx AS a
WHERE (NOT EXISTS
(SELECT jgdm
FROM dbo.Jgdm AS b
WHERE (a.qiyedm = jgdm)))
FROM dbo.Mpcx
WHERE qiyedm IS NULLUNION ALLSELECT ID, qiyedm, mingpailx, niandu, rendingsj, mingpaicpmc, pingpaisb, qiyemc, xianyu, beizhu
FROM dbo.Mpcx
WHERE NOT EXISTS (SELECT 1 FROM dbo.Jgdm WHERE Mpcx.qiyedm = Jgdm.jgdm)