How Do I Stop These Duplicates

I have these two tables and I cant prevent duplicates.


SEARCH


Item


ItemID


Info





CATEGORYDATA


CategoryID


ItemID





SELECT DISTINCT SEARCH.ItemId, SEARCH.Item, CATEGORYDATA.CategoryId


FROM SEARCH


INNER JOIN CATEGORYDATA


ON SEARCH.ItemID = CATEGORYDATA.ItemID


And I get something like:ItemID Item CategoryID


1 item1 1


3 item3 1


1 item1 2 <---duplicate


1 item1 3 <---duplicate


2 item2 3


4 item4 3


Thanks in advance