ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦Û°Ê§ì¨ú¸ê®Æ

[µo°Ý] ¦Û°Ê§ì¨ú¸ê®Æ

½Ð°Ýexcel¥i¹³access¤@¼Ë¡Akey¤JA¸ê®ÆµM«á¦Û°Ê·j¯Á¨ä¥¦¤u§@ªí¡AµM«á¥X²{B¡BC¡BD¸ê®Æ
A-²£«~½s¸¹
B-®w¦s
C-»ù®æ
D-­×§ï¤é´Á

¥»©«³Ì«á¥Ñ fusayloveme ©ó 2014-2-17 12:48 ½s¿è

¦^´_ 1# 013160

¥i¥H¡C
¦ý¥ý¨M±ø¥ó¬°¡A±z¥²¶·«Ø¥ß¦¹ A»PB¡BC¡BD¸ê®Æ¶¡ªºÃöÁp©Ê¡C

A¸ê®Æªí ¤¤ªº[²£«~½s¸¹]  ¥h¹ïÀ³   B¸ê®Æªí ¤¤ªº[²£«~½s¸¹]
»yªk¦p¤U¡G
SELECT
FROM [²£«~½s¸¹] LEFT JOIN [²£«~½s¸¹] ON [A].²£«~½s¸¹ = [B].²£«~½s¸¹;

[B]¸ê®Æªí¤ºªºÄæ¦ì¦³ ²£«~½s¸¹¡B»ù®æ

¦ý®w¦s»P­×§ï¤é´Á¬OÄÝ©ó³s°Ê¸ê®Æ¡A«Øij¤£©ñ¦b±`¥Î¸ê®Æªí¤º

¤£¹L¥i¥H¨Ï¥Î¸ê®Æªí¶¡Â²³æªº¹Bºâ¡A¨Ó¹F¨ì®w¦s¤Î­×§ï®É¶¡ªº«Ø¥ß

³o³¡¤À¦³¿³½ì¥i¥h¤U¸ü ¤@¯ë¶i¥X³fªº¸ê®Æ®w½d¨Ò¦^¨Ó¬ã¨s

TOP

¦^´_ 2# fusayloveme

ÁÂÁ«ü±Ð¡A§Ú¸Õ¸Õ¡A¦p¦³°ÝÃD¦b½Ð±Ð§A¡C

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD