SELECT m_result_detail.Link, m_result.ID, m_result.Enable, m_result.DateTime, m_result.Master , m_result.Path , m_result.Name, m_result.Speciality, m_result.Team, m_result.Duty, m_result.Remark, FROM m_result INNER JOIN m_result_detail ON m_result.ID = m_result_detail.Link WHERE HandleWork = 0
这条语句中的Path是重复数据怎么不让它重复，请指教。

DISTINCT 这个关键字肯定不行，会的些个例子。谢谢！

试:

SELECT m_result_detail.Link, m_result.ID, m_result.Enable, m_result.DateTime, m_result.Master , m_result.Path , m_result.Name, m_result.Speciality, m_result.Team, m_result.Duty, m_result.Remark into # FROM m_result INNER JOIN m_result_detail ON m_result.ID = m_result_detail.Link WHERE HandleWork = 0

declare @max int,@path varchar(300)
declare cur_rows cursor local for select path,count(*) from # group by path having count(*) > 1
open cur_rows
FETCH NEXT FROM cur_rows into @path,@max
WHILE @@FETCH_STATUS = 0
BEGIN
set rowcount @max

delete # where path = @path

FETCH NEXT FROM cur_rows into @path,@max
end
close cur_rows
set rowcount 0