Current Reporting Period 17, 01/01/07 to 02/03/07

Note: click on the headings to change what projects are being sorted onUnknown column 'P_OrgID' in 'on clause'Error: During SELECT query
SELECT `P_ProjectID`, `P_Title`, `P_Location`, `P_OrgID`, `P_Status`, `Prov_ProvinceName`, `Prov_Abbreviated`, (`P_BudgetLabour` + `P_BudgetTravel` + `P_BudgetOperating` + `P_BudgetCapital` + `P_BudgetOther`) as `Budget`, `Org_ID`, `Org_OrganisationCode`, `Org_Location`, `Org_Section`, `Org_Name`, `PS_StatusID`, `PS_Status` FROM `projects`, `province`, `projectstatus` LEFT JOIN `organisation` ON `Org_ID` = `P_OrgID` WHERE (`Prov_ProvinceName` = `P_Location`) AND (`P_Status` = `PS_StatusID`) ORDER BY `P_ProjectID`