I am new to SQL so bear with me. I am returning data from multiple tables. Followed is my SQL (let me know if there is a better approach):

```
SELECT [NonScrumStory].[IncidentNumber], [NonScrumStory].[Description], [DailyTaskHours].[ActivityDate], [Application].[AppName], [SupportCatagory].[Catagory], [DailyTaskHours].[PK_DailyTaskHours],n [NonScrumStory].[PK_NonScrumStory] 
FROM [NonScrumStory], [DailyTaskHours], [Application], [SupportCatagory] 
WHERE ([NonScrumStory].[UserId] = 26) 
AND ([NonScrumStory].[PK_NonScrumStory] = [DailyTaskHours].[NonScrumStoryId]) 
AND ([NonScrumStory].[CatagoryId] = [SupportCatagory].[PK_SupportCatagory]) 
AND ([NonScrumStory].[ApplicationId] = [Application].[PK_Application]) 
AND ([NonScrumStory].[Deleted] != 1) 
AND [DailyTaskHours].[ActivityDate] >= '1/1/1990' 
ORDER BY [DailyTaskHours].[ActivityDate] DESC

```

This is what is being returned:

![enter image description here](https://i.stack.imgur.com/XR02a.png)

This is nearly correct. I only want it to return one copy of PK\_NonScrumStory though and I can't figure out how. Essentially, I only want it to return one copy so one of the top two rows would not be returned.