mysql 查询返回多个结果

Question

我有以下查询，即使我添加了不同的记录，它也会返回 360 条重复记录:

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

从 Leadid = 208 的注释中选择 * - 它有 3 条记录:

从 Leadid = 208 的消息中选择 * 它有 15 条记录

从 Leadid = 208 的调用中选择 * 它有 8 条记录

Answer 1

修改 where 子句以消除连接表的 NULL 值

WHERE calls.LeadID IS NOT NULL AND notes.LeadID IS NOT NULL AND 
messages.LeadID IS NOT NULL AND leads.leadid = 208