PeterErhard
asked on
Update Query in mySQL
I'm wondering how I can do the below query in mySQL. Can someone help please?
Update Picks
Set Picks.Points = $PointsCorrectScoreJoker
Inner Join Matches on Picks.MatchesID = Matches.MatchesID
where Matches.MatchesID = $MatchesID
and Picks.PickTeamOne = $ActualScore_TeamHome and Picks.PickTeamTwo = $ActualScore_TeamAway
and Picks.Joker = 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER