I'm trying to get ouput from one table where certain conditions are met in the joined table. The problem is, I only want distinct records from the output table. I've tried using distinct with inner ...