diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp
index 3a42e6f..79e6ece 100644
--- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp
+++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp
@@ -470,9 +470,9 @@
 {
 QList<TestedDevice> result;
 QSqlQuery query;
-bool isSuccess = query.exec("SELECT eei.id ,eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.manufacturer ,bboi.customer_name ,sys_dept.FULL_NAME ,eei.meter_identify ,eei.check_cycle ,eei.certificate_valid   from eqpt_equipment_info eei "
-                           "  JOIN sys_dept ON sys_dept.ID = eei.dept_id "
-                            "  JOIN biz_business_order_info bboi ON bboi.customer_id = eei.company_id LIMIT 100");
+bool isSuccess = query.exec("SELECT DISTINCT  eei.id ,eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.manufacturer ,bboi.customer_name ,sys_dept.FULL_NAME ,eei.meter_identify ,eei.check_cycle ,eei.certificate_valid   from eqpt_equipment_info eei "
+                            " LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id "
+                            " LEFT JOIN biz_business_order_info bboi ON bboi.customer_id = eei.company_id ");
  if (isSuccess) {
          while (query.next()) {
              TestedDevice testedDevice;