ÈçÌ⣬дÁËÈçÏÂÒ»¶ÎSQLÓï¾ä£º
insert T_jitong6ximu(JT6ReportID,Reporter,Peishu)
select
T_jitong6.JT6ReportID,
»úͳ6.ÌáÆ±ÈË,
»úͳ6.ËùÊô³µ¼ä,
from »úͳ6,T_jitong6
where »úͳ6.³µÐÍ=T_jitong6.jixing
and »úͳ6.³µºÅ=T_jitong6.chehao
and »úͳ6.ÈÕÆÚ=T_jitong6.ReportTime
and »úͳ6.Èë¿âʱ¼ä=T_jitong6.ComeinTime
and not exists (select 1 from T_jitong6ximu where
JT6ReportID=T_jitong6.JT6ReportID and
Reporter =»úͳ6.ÌáÆ±ÈË
and Peishu = »úͳ6.ËùÊô³µ¼ä£©
ʵÏÖ¹¦ÄÜÈçÏÂÃèÊö£º
ÍùT_jitong6ximu²åÈëÊý¾ÝJT6ReportID,Reporter,Peishu
ÆäÖÐJT6ReportIDÓÉT_jitong6¶Á³ö£»
Reporter,PeishuÓÉ»úͳ6µÄÌáÆ±ÈË¡¢ËùÊô³µ¼ä¶Á³ö
JT6ReportIDΪintÐÍ£¬ÆäËûΪvarcharÐÍ¡£
T_jitong6Óë»úͳ6µÄ¹ØÁªÓÉwhereºóÃæµÄÓï¾äÁªÏµ
ÒòΪ²»ÄÜÍùT_jitong6ximu²åÈëÖØ¸´Êý¾Ý£¬ËùÒÔдÁËnot existsºóÃæµÄÄÚÈÝ
SQL±¾ÉíÊÇûÓÐÎÊÌâÁË£¬µ«ÊÇÖ´Ðжà´Î£¬»á²åÈëÖØ¸´Êý¾Ý¡£
²»ÖªµÀÔõô»ØÊ£¿
´ó¼Ò°ï濴һϡ£
лл£¡
ºÃºÃ¿´ÊéÈ¥Ðв»
ÊDz»ÊÇNOT EXISTSûÅжϺÃ
ÓпÉÄÜ»áÖØ¸´
Ó¦¸ÃÊÇNOT EXISTS Õⲿ·Ö³öÁËÎÊÌâÓ´£¡
ÒýÓà ºÃºÃ¿´ÊéÈ¥Ðв» ÎÒÊÇÏë¿´Ê飬¿ÉÊÇÃ÷Ìì¾ÍҪȥµ÷ÕâЩ×÷Òµ£¬ÊµÔÚû°ì·¨£¬½ñÌìÎÊÁ˺ܶàÎÊÌ⣬·¢ÏÖÆ½Ê±Ñ§µÄÌ«¸¡ÔêÁË£¬¹ýºóÒ»¶¨»áºÃ¿´ÊéµÄ¡£
ÒýÓà ÊDz»ÊÇNOT EXISTSûÅжϺÃ
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£ select * from ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE WhereÆäËûÌõ¼þ select * ......