Unique Key

From: Juan Carlos <jc_va_at_hotmail.com>
Date: Tue, 27 Jul 1999 15:00:06 -0700
Message-ID: <7nkvkh$fqe$1@bgtnsc02.worldnet.att.net>

We want to create a xref table for SSN and an Employee ID which will be different. The table will just be those two columns. But I have a dilemma. If I make SSN the PK, this would allow duplicate Employee ID's. If I make it a composite PK, it would be possible to have duplicate SSN's but different Employee ID's. Is there a way to make the unique and distinct at the same time without triggers?
JerryTWP: el subject debe ser "Unique Key" Received on Tue Jul 27 1999 - 17:00:06 CDT