[SOLVED] How to add DISTINCT to this

[tqla]

Hi. I get duplicates in my results becuase the relationship of the two databases in 1 to many.

 

How can I add DISTINCT to this select statement?

 

"SELECT 
*
FROM 
Clients cl
INNER JOIN CompaniesNew co ON co.ClientNum = cl.ID
WHERE
co.Year = '2007'
AND
co.Publish = 'Y'");

 

Thanks.

[jvrothjr]

You have to state which field is distinct

"select distinct cl.Name
   from clients cl 
       inner join CompaniesNew co on co.ClientNum = cl.ID 
   where co.Year = '2007' and co.Publish = 'y'"

[tqla]

Perfect. Thanks jvrothjr!

This topic is solved!