Hi.
A little help modifying select query to bring back first record only, i don't need to see all variations of the primary key which is NBN_Location_Id
SELECT dbo.NTT_Tracked_Path_Report.NBN_Location_Id, dbo.NTT_Tracked_Path_Report.ADBoR_Id, dbo.NTT_Tracked_Path_Report.ADBoR_Textual_Address
FROM dbo.NTT_Tracked_Path_Report
LEFT JOIN dbo.Book2 ON dbo.NTT_Tracked_Path_Report.NBN_Location_Id = dbo.Book2.NBN_Location_Id