I've built a database that creates the following query, which works fine, except that I don't get unique ContactIDs.

select Distinct(T_Contact.ContactID),
LastName, FirstName, T_Contact.ActiveInd, ContactTypeDescription,
T_ContactType.ContactTypeID, T_Organization.OrganizationID, OrganizationName
from
T_Contact
join T_ContactTypeContact on T_Contact.ContactID = T_ContactTypeContact.ContactID
join T_ContactType on T_ContactTypeContact.ContactTypeID = T_ContactType.ContactTypeID
join T_OrganizationContact on T_Contact.ContactID = T_OrganizationContact.ContactID
join T_Organization on T_OrganizationContact.OrganizationID = T_Organization.OrganizationID
where 1=1
     AND (T_Contact.ActiveInd = 1)
  AND (T_Contact.OwnerCompany = 1) ORDER BY T_Contact.ContactID

DISTINCT won't always give you unique values. It will give you unique values for each of the other parameters in your query. What exactly are you going to do with the unique contact IDs?