Ȳ¼ºÇÊ
|
2007-11-07 09:03:51, Á¶È¸ : 4,005, Ãßõ : 498 |
¾È³çÇϼ¼¿ä!
ȯ°æ : win2000 server, sql2000, asp
ÇÁ·Î±×·¥ ±¸¸Å¿¡ ¾Õ¼ ±Ã±ÝÇÑ Á¡À» ¿©Â庸°Ú½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º¿¡¼ Äõ¸®ÇÑ °á°ú°ªÀ» aspÆäÀÌÁö¿¡¼ ±×·¡ÇÁ·Î º¸¿©ÁÖ·Á°í ÇÕ´Ï´Ù.
->
Select Agencyname, Sum(Amt) From OrderDetail D
inner Join Orders O on D.Orderid=O.Orderid
Left Outer Join Agencies A on O.Agencyid=A.Agencyid
where O.OrderDate between '2007-09-01' and '2007-09-30'
Group by Agencyname
dbstat ÇÁ·Î±×·¥À¸·Î ±¸ÇöÀÌ °¡´ÉÇÑÁö¿ä?
Àú´Â ±×·¡ÇÁ¸¦ ¾ò±â À§ÇØ ±×¶§±×¶§ ÀڷḦ ÀÔ·ÂÇÏ´Â °Ô ¾Æ´Ï¶ó
asp ÆäÀÌÁö ±¸¹®»ó¿¡ sql Äõ¸®¸¦ ÅëÇØ
sql2000 ¿¡ ÀúÀåµÇ¾î ÀÖ´Â Á¤º¸¸¦ ºÒ·¯¿Í¼ º¸¿©ÁÖ·Á°í ÇÕ´Ï´Ù.
|
|
|