soccer - joining matches to a season

[limericklad1974]

hi there,

in my database, I have a match table, and one of the columns is matchdate

I also have a country table, where each country has an ID. I have a seasons table where each row is linked to a country and has a start date and end date.

I would like to update rows in the match table but restrict it to matches played in a certain season. How do I modify the following code to just update matches from a certain season?

update match
set date=
cast(Year(Date) as nvarchar) + '-' +
cast(Month(Date) as nvarchar) + '-' +
cast(Day(Date) as nvarchar)
+ ' 19:00:00.000'

Thanks