I think this is called "foreign key" and "local key" ?
I have a table
users, these users have
rank. It's an
There is a table named
rank, this table has field where hexadecimal string is placed
FF0000. Is there a way to
SELECT * FROM users and
SELECT * FROM rank WHERE id=users.rank... or something?