In a SQL database, how can I add a unique constraint that depends on a value in a foreign key linked table?

All we need is an easy explanation of the problem, so here it is. As an example, I have 2 tables: devices ----------------- id (Primary Key) logical_address physical_location (Foreign Key…

Continue ReadingIn a SQL database, how can I add a unique constraint that depends on a value in a foreign key linked table?