>SELECT P.Name, ; > A.AuthType, ; > A.Limit, ; > A.Fund, ; > A.Project, ; > A.Program, ; > A.Account, ; > A.SFS, ; > A.MCC, ; > O.Orgainization ; > FROM Org O ; > JOIN Author A ; > ON O.Organization = A.Organization > JOIN Person P ON A.ID = P.ID ; > WHERE (A.End > DATE() OR A.End={} ; > ORDER BY O.Orgainization, P.Name, A.AuthType >