I have two tables
tablename: users
fields
userid (int)
username (varchar) (PK)
password (nvarchar)
Tablename information
fields
id (int)
Name (varchar)
username (varchar) (FK)
section
userid (int)
I want to compare the values of username of information table. On the update the username should compare the oldvalue with the new value. if oldvalue is greater than new then userid set to "1" else "0". username should use the values of "userid" in users table.
thanks in advance