急!急!急! 有关GROUP BY 和 ORDER BY 问题
我现在编一个简单报表,格式
select table1.column1,table2.column2, ...
from table1 inner join table2,table2 inner join table3, ...
order by table1.column1,table2.column2
但是查询出来的结果有多行重复,我用DISTINCT语句系统提示
"The text ntext or image data type cannot be select as DISTINCT"
说明不能用文本或IMAGE DATA 进行排序,我又用GROUP BY并把DISTINCT 和ORDER BY去掉,系统提示
"Column table1.column1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
请教各位"高人"我着菜鸟如何去处这些重复的记录:),谢谢