ASP.Net query: adding a value from one table to another table where the ID´s match : So my problem is: 
I have a club table with a ClubId. This table has a field with the badge reference string. (I´ll acces the Picture itself through wwwroot). I now have a table with results. This results table has a hometeamId a hometeambadge field thats still empty and a awayteamId and a awayteambadge field thats also empty. I now want to write a methode where I add the badge string from the club table into the results table where the ClubId is equal to the hometeamId and the awayteamId. How do I do this in a query in ASP.Net Core ?