I am performing a left join, table 'Individual' only has one record per 'person', it joins a list of addresses, but there may be more than one address per person. I want to join only to the first address if there is a case in which there is more than one so not to get more than one result per person.
This is my current code:
LEFT JOIN dbo.BDotAddressesHome ON [TrackerSostrin].[dbo].[Individual].[IndivID] = [TrackerSostrin].[dbo].[BDotAddressesHome].[IndivID]
So Individual would need to left join BDotAddressesHome but only the top record.