I was wondering if its possible to create a unique index that works across 2 tables.
Currently I have,
Users - username, password, email
Temp Users - username, password, email, confirmation_code
I want to make sure that the username doesn't get duplicated across 2 tables.
Is there a way to do this without having to do a query to both tables?