>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 > >