New answers tagged

1

The problem with this model is that you did not identify all candidate keys in the relation and did not enforce uniqueness of those keys you did not identify. In reality {SSN} and, possibly, {Name, DoB, SomethingElse} would constitute additional candidate keys. Nevertheless, Id is still the primary key of this relation, but it does not identify the entity ...


0

If the only two references from the table GccTbl_Sales are the columns iCustomerId and tsDepart, this should work: SELECT DISTINCT iRecipientId AS RecipientID, NmsRecipient.iCustomerId AS Cust_Num, sFirstName AS FirstName, sLastName AS LastName, sEmail AS Email, iBlacklistPostalMail AS NoMail, iBlacklistEmail AS NoEmail, iBlacklistMailGCCL AS DontMailGCCL, ...


Top 50 recent answers are included