python输出sql语句怎么写

def _get_cust_number(self,cr,uid,ids,field_name,args,context=None):

res={}
for order in self.browse(cr, uid, ids, context=context):
   #获取单据信息     
   aa=order.origin
        if aa:
            sql="select t1.cust_numr_no from stock_fah t0 left join sale_orde t1 on t0.origin=t1.name where t0.origin='%s'"%(aa)
            cr.execute(sql)
            dict4=cr.dictfetchall()
            if dict4:
                dd=dict4[0]['cust_numr_no']
                res[order.id]=dd
            else:
                res[order.id]=''
        else:
            res[order.id]=''
return res