Posted by Jim Michaels on 01/09/06 11:10

these are easy: If I am correct, this should do nicely:

AND ( ( (SELECT MAX(tc.item_version) FROM tc WHERE tc.lang_id = 001) -
(SELECT MAX(tc.item_version) FROM tc WHERE tc.lang_id = 002) ) < 2 )


> AND ( ( MAX(tc.item_version WHERE tc.lang_id = 001) - MAX(tc.item_version
> WHERE tc.lang_id = 002) ) < 2 )

[Back to original message]