stop duplication

Results 1 to 2 of 2

Thread: stop duplication

  1. #1
    Join Date
    Dec 1969

    Default stop duplication

    Is there some way i can stop duplicate redords from showing up in my dataset? as an example i am usuing something like this SQL string:<BR><BR>SELECT Attendees.LastName, Attendees.FirstName, Attendees.Organization, Attendees.Phone, Attendees.Ext, Attendees.Fax, Attendees.Email FROM Attendees INNER JOIN BigOlTable ON (Attendees.AttendeeID = BigOlTable.AttendeeID AND (BigOlTable.EventID = &#039;E03&#039; OR BigOlTable.EventID = &#039;E04&#039;)) ORDER BY Attendees.LastName <BR><BR>I run into problems because some AttendeeID&#039;s have entries for multiple eventID&#039;s

  2. #2
    Join Date
    Dec 1969

    Default primary keys

    give whatever you want to be unique a primary key constraint

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts