Hi, I have an inner join involving the tables 'arrest' and 'arr_log'. For each 'arrestno' in the arrest table there are many occurrences of it in the arr_log table. It returns a record for each match, but I only want it to return one row and I do not care which one.
FROM Arrest a inner join
arr_log b on a.arrestno = b.key1
inner join empmast c on b.user_key = c.PERNO
WHERE a.ARRESTTYPE = 'W' AND
a.servebyd BETWEEN @StartDate AND dateadd(day,1,@EndDate)
ORDER BY b.event_date desc
I would greatly appreciate your help. Thanks so much.