主题：请对SQL厉害的大神教授一下复杂SQL的一些疑点

select a.FID,

       a.fnumber as customerNumber,

       a.fname_l2 as customerName,

       son.fname_l2 as personname

  f rom t_bd_customer a

  left join T_BD_Region on T_BD_Region.fid = a.fregionid

  left join t_bd_customersaleinfo fo on fo.fcustomerid = a.fid

  left join t_bd_customersaler ler on ler.fcustomersaleid = fo.fid

  left join t_bd_person son on son.fid = ler.fpersonid

 where 1 = 1

   and (a.FBrowseGroupID = 'jPJnAQEUEADgAc3iwKgCZ3olaaI=')

   and a.fname_l2 not like '%成品箱%'

 order by a.fnumber

以上的SQL 比较复杂 

在复杂业务的情况下 复杂的SQL会引发难以维护的结果 N多表的关联 

狐表在这方面有什么好的建议与方法  尽量降低维护度