UPDATEdbo.T_PartyBuildSETBirth=t.biFROM(SELECTDISTINCTb.BirthASbi,a.Person_IDASpeFROMdbo.T_PartyBuildASaLEFTJOINT_personASbONa.Person_ID=b.Person_ID)AStWHERET_P...