quote:
Originally posted by Jimbo
... list all the differences between integer fields if the difference is > 10...
Meaning you need to check if A is more than 10 bigger than B
AND if A is more than 10
smaller than B, correct?. So...
quote:
Originally posted by matty
A.playerupgrade1 > ( B.playerupgrade1 + 10)
That will not list values in B which are at least 10 bigger than A; it will only list values in B which are at least 10 less than A!
Thus the correct clause would then be:
SQL code:
...
WHERE (
ABS(A.playerupgrade1 - B.playerupgrade1) > 10
OR ABS(A.playerupgrade2 - B.playerupgrade2) > 10
OR ABS(A.playerupgrade3 - B.playerupgrade3) > 10
OR ABS(A.playerupgrade4 - B.playerupgrade4) > 10
)
ABS() = take the absolute value of the number
------------
EDIT:
quote:
Originally posted by Jimbo
Well, the nature of my table, makes it impossible for the record to decrease from B to A
Ah... In that case I never said anything
/ 
