相同记录只显示1次的问题？

麻烦大家帮忙看一下，下面是我的代码：

<%

sql="SELECT Department.Department, Department.Dept_ID, Personnel.Personnel_ID, Personnel.TrueName FROM Department INNER JOIN Personnel ON Department.Dept_ID = Personnel.Dept_ID WHERE Fired=0 ORDER BY Department.Dept_ID "

call openDB()

rs.open sql,conn,1,1

%>

问题是：会出现记录重复的现象！

然后更正代码如下：

<%

sql="SELECT DISTINCT Department.Department, Department.Dept_ID, Personnel.Personnel_ID, Personnel.TrueName FROM Department INNER JOIN Personnel ON Department.Dept_ID = Personnel.Dept_ID WHERE Fired=0 ORDER BY Department.Dept_ID "

call openDB()

rs.open sql,conn,1,1

%>

浏览器返回的错误信息是：最后一行代码“，”号附近有错误

该怎么解决？

[615 byte] By [msdn] at [2007-8-14 9:08:25]