Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»Ìõ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<


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......

ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Ô­SQLÓï¾äSQL code:

SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ',
t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ