Hi! I have table A:  PatId  Date Country
and table B: PatId Unit Code
 
I need to join them by PatId with a condition in the Date field and show the results with no repeated PatIds,
 
This is not working:
 
Select DISTINCT(PatId), Date, Country, Unit, Code
from A
 JOIN B ON (A.PatId=B.PatId)
  where (A.Date >= 01/01/2008 and A.Date <= 31/12/2008)
order by PatId
 
I tried to group by and then select distinct by it's not working, how could I select distinct?
Sorry for this question that seems to be too easy but can't solve it...




[Non-text portions of this message have been removed]