better sql syntax
Posted on 2011-09-09
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,activities.dateinitiated,activities.lastmodified,activities.processtep,activities.Partylist
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