|
|
|
|
ûÇæÔñýѨ / 2002-09-03 / ¿ÀÈÄ 1:42:49 / 203.255.3.190
Á¶È¸¼ö : 150
|
[Áú¹®] ÀÌ°Ç ¹«½¼ ¸Þ¼¼Áö¿¡¿©??? |
> [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'dage_com.code' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.
> /shop/09/index.asp, line 114
>
-----------------------------------------------------------
ÇØ´ç ¿¡·¯´Â order byÀý¿¡ »ç¿ëÇÑ Ä®·³Àº code¶õ ³ðÀÌ
aggregate function¿¡ Æ÷ÇÔµÇÁö ¾Ê°í group byÀý¿¡ ³ª¿Í ÀÖÁö ¾Ê´Ù´Â ¶æÀÔ´Ï´Ù.
group by¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ÄÚ³´ÔÀÇ È¨ÆäÀÌÁö¸¦ Âü°íÇϽñ⠹ٶø´Ï´Ù.
http://sqler.pe.kr/sql2k/28.asp
|
|
|