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

access¬d¸ß

access¬d¸ß

³]¥ß¤@­Ó¬d¸ß ¡Asql¦p¤U¡G
SELECT [¶^­Ë¤G¦¸¥H¤W¤H¼Æ ¬d¸ß].¤ë¥÷, Count([¶^­Ë¤G¦¸¥H¤W¤H¼Æ ¬d¸ß].¯f¾ú¸¹½X) AS ¯f¾ú¸¹½X¤§µ§¼Æ1
FROM [¶^­Ë¤G¦¸¥H¤W¤H¼Æ ¬d¸ß]
GROUP BY [¶^­Ë¤G¦¸¥H¤W¤H¼Æ ¬d¸ß].¤ë¥÷;


·Q½Ð°Ý¤@¤U¦pªG·Q­n´Nºâ¬Y¤ë¨S¦³µo¥ÍÂܭˤG¦¸¥H¤Wªº¤H¼Æ
¤]·Q­n¦b¬d¸ß¸Ì¬O¥i¥H¥X²{¤ë¥÷
  ¦~   ¤ë             µ§¼Æ  
10301                0
10302                2  
10303                6
¬O§_¦³¿ìªk¥i¥H¿ì¨ì©O¡HÁÂÁÂ

«Ø¥ß¤@¼Ð·Ç¦~¤ë¸ê®Æªí¬°STD,
¤º¥u¦³Äæ¦ì[¦~¤ë],
¤º®e¬°
10301
10302
10304
10305
......

¦A°Ñ¦Ò¤U¬d¸ßSQL§Y¥i±o.
SRC§Y§Aªº¸ê®Æªí.

SELECT STD.ym, Count(SRC.Num) AS Num¤§µ§¼Æ
FROM STD LEFT JOIN SRC ON STD.ym = SRC.YM
GROUP BY STD.ym;

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD