Stan..
DISTINCT keyword will return unique ROWS from the entire Select statement
You use derived tables in SQL to modify the tables you are joining
SELECT DISTINCT dbo.work.ext_document_no,
dbo.work.entry_date,
dbo.employee.first_name As TechF,
dbo.employee.last_name As TechL
FROM dbo.work work
INNER JOIN (Select Distinct work_no,
technician_id
FROM dbo.Work_Act ) account ON work.work_no = account.work_no
INNER JOIN (Select DISTINCT technician_id,
first_name as TechF,
last_name as TechL
FROM dbo.employee) employee on account.technician_id = empoyee.technician_id
WHERE work.ext_document_no = '|wo|'
as an example..
which table is the source of the duplicate rows?