I have the following query that I use for displaying a list of companies by industry Segment i.e. Engineering, construction, etc. the ID for the segment that I require is 11. Everything works fine until here. However, if I add to the database another user that happens to work for the same company my list will show the same company twice. how can I display the list of companies without duplicating.

Any ideas?

SELECT intCompanyID, intSegment, txtCompanyName
FROM tblUsers, tblCompanies
WHERE intCompanyID = intCompID AND intSegment LIKE 11
ORDER BY txtCompanyName ASC

SELECT DISTINCT, rather than just SELECT should do it.

Thanks Michael, it worked.


Cheers,
Javier