select TOP 100 a.CustomerID, b.industryName, c.occupationName, d.countryName, a.CompanyTypeOther, a.EmployeeTypeOther, a.Nationality, a.NationalityOther, a.Sex, a.MinAge,a.MaxAge, a.Japanese, a.Chinese, a.SalaryMonthFrom, a.SalaryMonthTo, a.SalaryUnit, a.InputDay, a.WorkPlace from FindHumanOutput a, Industry b, Occupation c, Country d where (a.Area='1' or a.Area='51') and a.CompanyType = b.industryId and a.EmployeeType = c.occupationId and a.Nationality = d.countryId and a.WorkPlace like '%蘇州%' order by a.UsualOpen DESC, a.InputDay desc, a.CustomerID desc