Aleks
asked on
better sql syntax
I have the following query, can we make it better? Please refer to my prev posting as example, that worked real nice.
--
SELECT activities.activityid, activities.ActName, activities.actdesc,activit ies.datein itiated,ac tivities.l astmodifie d,activiti es.process tep,activi ties.Party list
FROM ((dbo.Activities LEFT JOIN dbo.Cases ON dbo.Activities.CaseId = dbo.Cases.Id) )
LEFT JOIN dbo.Atts ON dbo.Atts.CaseId = dbo.Cases.Id
INNER JOIN Users ON Activities.sent_by = Users.UserId
WHERE Activities.FirmId = 2 AND (Activities.ActType = 'Calendar') AND sent_by = 1713
---
Aleks
--
SELECT activities.activityid, activities.ActName, activities.actdesc,activit
FROM ((dbo.Activities LEFT JOIN dbo.Cases ON dbo.Activities.CaseId = dbo.Cases.Id) )
LEFT JOIN dbo.Atts ON dbo.Atts.CaseId = dbo.Cases.Id
INNER JOIN Users ON Activities.sent_by = Users.UserId
WHERE Activities.FirmId = 2 AND (Activities.ActType = 'Calendar') AND sent_by = 1713
---
Aleks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What indexes do you have on the tables?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
ASKER
https://www.experts-exchange.com/questions/27300026/better-sql-syntax.html