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

Á½ÕÅ×Ö¶ÎÏàͬ±í£¬ÇóSQLÓï¾ä£¬Ð»Ð»´ó¼Ò

ÓÐÁ½ÕÅ×Ö¶ÎÏàͬµÄ±íA£¬B¡£×Ö¶ÎΪSN, Name, Operator, Result, Remark
A±íÖÐ×Ö¶ÎSNΨһ£¬B±íÖÐ×Ö¶ÎSN²»Î¨Ò»£¬ÓкܶàÌõ
ÈçºÎÓÃÒ»ÌõselectÓï¾ä
°Ñ·ûºÏSN=¡¯abc¡¯µÄ¼Ç¼´ÓA£¬B±íÖÐɸѡ³öÀ´£¿



SQL code:
SELECT *
from A
INNER JOIN B ON A.SN=B.SN AND A.SN='abc'


SQL code:
select * from a where SN='abc'
union all
select * from b where SN='abc'


select * from a where SN='abc'
union all
select * from b where SN='abc'

ÄãÃǺÿ졣¡£

лл´ó¼Ò£¬½â¾öµÄÌ«¿ìÁË£¬¿´À´ÎÒµÄÎÊÌâÌ«¼òµ¥ÁË¡£¡£¡£¡£¡£ º¹
µ«ÊÇ»¹ÊÇлл´ó¼Ò£º£©

js_szy ºÍSNΨһû¹ØÏµ£¬ºÇºÇ Ö»ÊÇ·¢ÎʵÄʱºòÏë°ÑÎÊÌâÃèÊöÇå³þ ллÄãµÄ½â´ð°¡


Ïà¹ØÎÊ´ð£º

Çó Æ´VB SQL insert into ×Ö·û´®

  INSERT INTO StudAchieve(studID,studName)
  VALUES('2','abc'),('2','bcd'),('2','cde')

  Æ´Á˰ëÌìÒ²²»¶Ô£¬¼°°¡ ¡£¡£¡£¡£
SQL c ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

ORACLE sqlÓï¾äµÄÎÊÌâ

  ÏÖÔÚÓбíA£¨barcode varchar2£¬length number£©£¬B£¨barcode varchar2£¬serial number£©ÆäÖÐbarcode¹ØÁªA:BΪ1£ºn

ÓÐÈçÏÂsqlÓï¾ä
insert into a values('b1',10)
insert into a values( ......

ÇóÖúÒ»¾äSQLÓï¾ä

Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float

Êý¾ÝÈçÏ£º

Code      CreateTime          Price
031002 2008-10-17 15:00:15 ......

Çósql´¥·¢Æ÷Óï¾ä

users±í
name  companyId  companyName


company±í
companyId  companyName
1          a¹«Ë¾
2          b¹«Ë¾
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ