matty
Scripting Guru
Posts: 8336
Reputation: 109
39 /  / 
Joined: Dec 2002
Status: Away
|
RE: MySQL - Compare 2 tables
Oops I screwed up
sql code:
SELECT * FROM upgrades A
INNER JOIN upgrades_backup B ON B.steamid = A.steamid
WHERE (
A.playerupgrade1 > ( B.playerupgrade1 + 10)
OR A.playerupgrade2 > ( B.playerupgrade2 + 10 )
OR A.playerupgrade3 > ( B.playerupgrade3 + 10 )
OR A.playerupgrade4 > ( B.playerupgrade4 + 10 )
)
This post was edited on 10-08-2009 at 03:02 PM by matty.
|
|
