The following query works fine if there is only one record in TableC for a CustID. But, in my case, there are multiple records for a CustID in Table C.
How do I fix this query so it would take the 1st record for each CustID ?
update a
set a.CustCity =c.CustCity
from TableA a
inner join TableB b on a.CustNumber=b.CustNumber
inner join TableC c on b.CustID=c.CustNumber