Á½ÕÅ×Ö¶ÎÏàͬ±í£¬Çó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Ψһû¹ØÏµ£¬ºÇºÇ Ö»ÊÇ·¢ÎʵÄʱºòÏë°ÑÎÊÌâÃèÊöÇå³þ ллÄãµÄ½â´ð°¡
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
±ÈÈç ÎÒÓÐÒ»¸ö±í bumen
ÀïÃæ ÓÐÒ»¸öÁÐ quanxian
id name quanxian
1 a 001;002;003;
2 b 002;003;
3 ......
sqlÓï¾ä£º
select loan_plan_id,l_collect_plan.loan_id,l_collect_detail.collect_isfinished from l_collect_plan
left join l_collect_detail on l_collect_plan.return_times=l_collect_detail.collect_vo ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float
Êý¾ÝÈçÏ£º
Code CreateTime Price
031021 2008-10-17 15:00:1 ......