In Zoho Analytics I have an SQL Query that has multiple Left Joins. These Left Joins are causing some duplication of data, which for the most part is okay, as I can use a distinct count to collect data between certain things. 

I am trying to display some notes in a Tabular view from this SQL, and I can't seem to find a way to only display unique Note IDs.

Any ideas?