hi, i am new to the forum and have a problem with a query that i am trying to write which will do this:-

If [leaguetable_premier].[team name] = [leagueresults_premier].[home team] then
If [home goals] > [away goals] add 1 to [leaguetable_premier].[team name] in the [win] column
or If [home goals] = [away goals] add 1 to [leaguetable_premier].[team name] in the [draw] column
or If [home goals] < [away goals] add 1 to [leaguetable_premier].[team name] in the [lose] column

and vise versa with the away team..

My questions are:-
Is this possible?
Can anyone suggest code i can use?

All feedback will be much appreciated