mysql query returning me multiple results
<p>I have the following query and it is returning me 360 records with duplicates, even if I added distinct: </p>

<pre><code>SELECT DISTINCT
leads.FirstName,
leads.LastName,
calls.callDate,
calls.callstatus,
calls.calllog,
calls.whoCalled,
notes.Notes,
notes.`TimeStamp`,
messages.sentDate,
messages.`subject`,
messages.greeting,
messages.message,
messages.toEmail,
messages.whoSent
FROM
leads  
left JOIN calls ON calls.LeadID = leads.LeadID 
right join notes on leads.LeadID = notes.LeadID 
right join messages on leads.LeadID = messages.LeadID where leads.leadid = 208
</code></pre>

<p><code>select * from notes where leadid = 208</code> - it has 3 records: </p>

<p><code>select * from messages where leadid = 208</code> it has 15 records</p>

<p><code>select * from calls where leadid = 208</code> it has 8 records </p>