SELECT DISTINCT?

When I just - SELECT DISTINCT atblProducts.ID AS ProductID, it selects
distinct Product IDs but when I add the rest of them to the select, it
doesn't select the ProductID as DISTINCT.

Lionstone?

SELECT DISTINCT
dbo.atblProducts.ID AS ProductID, dbo.Categories.ID AS Categories,
dbo.atblProducts.Price AS Price, dbo.atblDescription.Paragraph AS
Description, dbo.atblProducts.Name AS Name
FROM dbo.atblProducts INNER JOIN dbo.Groups ON
dbo.atblProducts.ID = dbo.Groups.pid INNER JOIN dbo.PCat ON
dbo.Groups.gid = dbo.PCat.gid INNER JOIN dbo.Categories ON dbo.PCat.cid
= dbo.Categories.ID LEFT OUTER JOINdbo.atblDescription ON dbo.Groups.pid
= dbo.atblDescription.PID
WHERE (dbo.atblProducts.Price IS NOT NULL)
AND(dbo.atblProducts.Price <> 0)
ORDER BY dbo.atblProducts.ID