Link to home
Start Free TrialLog in
Avatar of PeterErhard
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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PeterErhard
PeterErhard

ASKER

Thanks :)