SELECT p.*, a.CompanyName, a.FirstName, a.LastName FROM ics2data.projects p LEFT OUTER JOIN ics2data.agents a ON a.ID=p.AgentID ORDER BY a.LastName, a.FirstName, p.ProjectName ICS-CONNECT ADMINISTRATION - List All Projects
#Client.StatMsg#



SUMMARY OF ALL PROJECTS
Project Name Agent Name Created Actions
#GetProjects.ProjectName#
#GetProjects.FirstName# #GetProjects.LastName#
#DateFormat(GetProjects.DateCreated, 'mmm dd, yyyy')#
Click to Edit the Project.   Click to send an e-mail to #GetProjects.FirstName# #GetProjects.LastName#
Contact: #GetProjects.ContactFirstName# #GetProjects.ContactLastName# Unassigned #GetProjects.ContactEmail# #GetProjects.ContactPhoneNumber#
CODE: #GetProjects.ProjectCode# TYPE: #ReplaceList(GetProjects.UnitType, "S,P", "Standard,Promotional")# ALLOCATED: #NumberFormat(GetProjects.UnitsAllocated, '999,999')# USED: #NumberFormat(GetProjects.UnitsUsed, '999,999')#