SELECT tblcompanies.*, countryName, stateName, employeesDescr, turnoverDescr FROM tblcompanies INNER JOIN tblcountries ON tblcountries.countryCode = tblcompanies.countryCode INNER JOIN tblemployees ON tblemployees.employeesID = tblcompanies.employeesID INNER JOIN tblturnover ON tblturnover.turnoverID = tblcompanies.turnoverID LEFT JOIN tblusstates ON tblusstates.stateCode = tblcompanies.usState WHERE companyID =