md_YOS/src/custom/restcontroller/webmanage/sale/enterprise/SQL/商户档案列表查询.sql

select t1.siteid,
       t1.sys_enterpriseid,
       t1.createby,
       t1.createdate,
       t1.changeby,
       t1.changedate,
       t1.city,
       t1.county,
       t1.address,
       t1.phonenumber,
       t1.province,
       t1.contact,
       t1.enterprisename,
       t1.taxno,
       t1.limitreturnday,
       t1.freefreightamount,
       t1.latitude,
       t1.longitude,
       t1.invoicingpoint,
       t1.saleclassauth,
       t1.grade,
       t1.isorder,
       t1.idcard,
       t2.sa_customersid,
       t2.type,
       t3.agentnum,
       t9.erpagentnum
from sys_enterprise t1
         LEFT JOIN sa_customers t2 ON t1.sys_enterpriseid = t2.sys_enterpriseid and t1.siteid = t2.siteid
         left join sa_agents t3 on t1.siteid = t3.siteid and t1.sys_enterpriseid = t3.sys_enterpriseid
         LEFT JOIN sys_dataextend t9 ON t1.sys_enterpriseid = t9.ownerid  and ownertable='sys_enterprise' and  t1.siteid = t9.siteid
where t1.siteid = $siteid$
  and $where$