SELECT Assessors.cFax, ; Audits.cCert, ; Customers.cCompany, ; Audits.dAuditSched, ; Audits.cAudit_Types, ; Audits.cAudSubType, ; Standards.cStandard, ; Standards.cStndDate, ; Customers.cPCity, ; Customers.cPState, ; Audits.cAuditID, ; Assessors.cLast_Name, ; Assessors.cFirst_Name, ; (RTRIM(clast_name)+', '+cfirst_name), ; Audit_team.cInitials, ; Audit_team.cJob, ; Audit_team.dStart, ; Audit_team.dEnd, ; Audit_team.nAudit_Days, ; Employees.cName, ; Status_codes.cDescription; FROM dbo.Audits Audits ; LEFT JOIN dbo.Registration Registration ; ON Audits.cRegistration_cId = Registration.cId ; LEFT JOIN dbo.Status_Codes Status_codes ; ON Registration.cStatus_Codes_cid = Status_codes.cId ; LEFT JOIN dbo.Employees Employees ; ON Registration.cResponsible = Employees.cId ; LEFT JOIN dbo.Audit_Team Audit_team ; ON Audits.cAuditID = Audit_team.cAuditID ; LEFT JOIN dbo.Assessors Assessors ; ON Audit_team.cAssessors_cId = Assessors.cId ; LEFT JOIN dbo.Standards Standards ; ON Audits.cAudStd_cid = Standards.cid ; LEFT JOIN dbo.Customers Customers ; ON Registration.cCustomers_cid = Customers.cId ; WHERE (Audits.dStart >= getdate() ; OR Audits.dStart IS NULL) ; AND Assessors.cId = ( ?VP_Assessors_cId ) ; ORDER BY Audit_team.dStart