ÈçÌ⣬ÏëʵÏÖÈçÏÂÃèÊöµÄЧ¹û£¬ jcxhÓëch²»Í¬Ê±ÏàµÈ¡£ Èç µÚÒ»ÌõÊý¾ÝΪjcxh=1 ch=2 µÚ¶þÌõÊý¾ÝΪjcxh=1 ch=3ΪÂú×ãÌõ¼þ Èç¹ûµÚ¶þÌõÊý¾ÝΪjcxh=1 ch=2¾Í²»Âú×ãÌõ¼þ дµÄSQL Ìõ¼þÓï¾äÈçÏ£º where jcxh not in (select jcxh from ±íA ) and ch not in (select ch from ±íA) µ«ÊǸоõºÃÏñ²»¶Ô£¬Çë¸÷λ´óÏÀ°ï濴һϡ£´ó¼Ò°ï濴һϣ¬Ó¦¸ÃÔõôд£¿ SELECT * from TB T WHERE EXISTS(SELECT 1 from TB T WHERE jcxh=T.jcxh AND ch <>T.ch) ûÓп´¶®£¡
µÚ¶þÌõÊý¾ÝΪjcxh=2 ch=2ÊÇ·ñÒ²Âú×ãÌõ¼þ ? insert into ±íB (jx,ch) select jcxh,ch from ±íA where jcxh not in (select jx from ±íB ) and ch not in (select ch from ±íB)