ÇóÒ»ÌõsqlÓï¾ä - MS-SQL Server / »ù´¡Àà
ǰÌ⣺ ÓÐÁ½¸ö±íji1£¬ji2 ji1ÖÐÓÐdhÁÐÓëji2ÖÐdhÁÐÊÇÒ»¶Ô¶àµÄ¹ØÏµ¡£ ÀýÈ磺 ji1 ji2 dh title dh title objno 010203 xxx 010203 www 0 010203 fff null 010203 jjj ÒªÇó£º ji2ÖÐÓÐÒ»ÁÐobjno£¨×Ö·ûÐÍ£©£¬ÆäÖÐÓÐ0£¬null£¬¿Õ¸ñ¡£ ҪѡÔñ³öobjnoÖеÄֵΪÒÔÉÏÖµµÄdhÁжÔÓ¦ji1ÖÐÐÅÏ¢¡£
SQL code: select j1.* from ji2 j2 left join ji1 j1 on j1.dh=j2.dh where j2.objno='0' or j2.objno is null or j2.objno='' SQL code: select a.* from ji1 a join ji2 b on a.dh=b.dh where b.objno='0' or len(isnull(objno,''))=0 ÎҸղŰÑobjno is null·ÅÔÚ×îºóÔõô¾Í²»ÐÐÄØ £¿ SQL code: select ji1.* , ji2.* from ji1 m, ji2 n where m.dh = n.dh and (n.objno = '0' or n.objno is null or n.objno = '' or len(rtrim(ltrim(n.objno))) = 0) ÕâÁ½ÖÖ·½·¨ÓÐʲô²»Ò»ÑùÂð ½è¹ó±¦µØ»Ø¸öÌû×Ó£¬×¬µã¶ù¿ÉÓ÷֣¬ºÇºÇ£¡ÒýÓà SQL code select ji1.* , ji2.* from ji1 m, ji2 n<
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏ ±íÃû: hisdata ×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä Id value state dattime 101 32.3 0 ......
ÔSQLÓï¾äSQL code: SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ', t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......