I have the following sql to select a number of records. I get a total of 280
SELECT *FROM Activities a INNER JOIN Cases AS b ON a.CaseId = b.Id INNER JOIN Atts AS d ON d.CaseId = b.Id LEFT JOIN Users AS c ON a.responsible = c.UserId INNER JOIN Users AS e ON b.AlienId = e.UserIdWHERE a.FirmId = 9 AND ( a.ActType = 'TASK' OR a.ActType = 'DEADLINE' ) AND a.Complete = '0' AND a.DateInitiated < LEFT(DATEADD(DAY, 0, GETDATE()), 12) AND b.Archived <> 1 AND c.UserId is nullORDER BY c.MailStr ASC;
DELETEFROM Activities a INNER JOIN Cases AS b ON a.CaseId = b.Id INNER JOIN Atts AS d ON d.CaseId = b.Id LEFT JOIN Users AS c ON a.responsible = c.UserId INNER JOIN Users AS e ON b.AlienId = e.UserIdWHERE a.FirmId = 9 AND ( a.ActType = 'TASK' OR a.ActType = 'DEADLINE' ) AND a.Complete = '0' AND a.DateInitiated < LEFT(DATEADD(DAY, 0, GETDATE()), 12) AND b.Archived <> 1 AND c.UserId is null
The delete was that of 89 records. But when I run the select again I get zero results :$
Is this correct ? the select returns more records because of the inner joins ?