Distinct Query
 

I have a query that I need help with the Syntax on.

SELECT CHIDspec.File, CHIDspec.`Lbx ID`, CHIUKReport.`CD Encrypt`
FROM {oj `G:\tEST`.CHIDspec CHIDspec LEFT OUTER JOIN
`G:tEST`.CHIUKReport CHIUKReport ON CHIDspec.`Lbx ID` =
CHIUKReport.File}

I need to pull distinct data from CHIDspec.`Lbx ID`, and I'm not sure
how to work in the "distinct" command for this query

Thanks