T SQL Script: BACAS Get All Graves

SELECT     DISTINCT dbo.tblMainLocation.Description AS Cemetery, dbo.getSubLocationDesc(dbo.tblDetailedLocation.[Sub Location Id]) AS Area, 

                      dbo.getGraveDesc(dbo.tblDetailedLocation.ID) AS GraveNo, dbo.tblDetailedLocation.ID AS GraveID, tblGraveContract_1.[Grant No] AS GrantNo, 

                      dbo.vieGraveOwnersCurrent.GraveOwner

FROM         dbo.tblDetailedLocation INNER JOIN

                      dbo.tblMainLocation ON dbo.tblDetailedLocation.[Main Location Id] = dbo.tblMainLocation.ID LEFT OUTER JOIN

                      dbo.vieGraveOwnersCurrent ON dbo.tblDetailedLocation.ID = dbo.vieGraveOwnersCurrent.[Grave ID] LEFT OUTER JOIN

                      dbo.tblGraveContract AS tblGraveContract_1 ON dbo.tblDetailedLocation.ID = tblGraveContract_1.[Grave ID]

 

ORDER BY Cemetery, Area, GraveNo