SELECT   GL_accvouch.iperiod AS [会计期间],GL_accvouch.csign AS [凭证类别字],  GL_accvouch.ino_id AS [凭证编号],GL_accvouch.inid AS [行号],GL_accvouch.cdigest AS [摘要],  Left(code.ccode , 4) AS [一级科目编码], code1.ccode_name AS [一级科目名称],  Left(code.ccode , 6) AS [二级科目编码],code2.ccode_name AS [二级科目名称],  GL_accvouch.ccode AS [科目编码],code.ccode_name AS [科目名称],  GL_accvouch.md AS [借方金额],GL_accvouch.mc AS [贷方金额],  GL_accvouch.cexch_name AS [币种名称],GL_accvouch.md_f AS [外币借方金额],  GL_accvouch.mc_f AS [外币贷方金额],GL_accvouch.nfrat AS [汇率],GL_accvouch.nd_s AS [数量借方],  GL_accvouch.nc_s AS [数量贷方],GL_accvouch.dbill_date AS [制单日期],GL_accvouch.cbill AS [制单人],  GL_accvouch.ccheck AS [审核人],GL_accvouch.cbook AS [记账人],GL_accvouch.ibook AS [记账标志],  GL_accvouch.cdept_id AS [部门编码],Department.cDepName AS [部门名称],GL_accvouch.ccus_id AS [客户编码],  GL_accvouch.csup_id AS [供应商编码],Vendor.cVenName AS [供应商名称],GL_accvouch.ioutyear AS [外部凭证会计年度],  GL_accvouch.coutsysname AS [外部凭证系统名称],GL_accvouch.ioutperiod AS [外部凭证会计期间],  GL_accvouch.coutid AS [外部凭证单据号]  

FROM GL_accvouch LEFT JOIN Department ON  Department.cDepCode= GL_accvouch.cdept_id

Left Join Vendor  on Vendor.cVenCode=GL_accvouch.csup_id,code,code as code1,code as code2  where GL_accvouch.ccode = code.ccode and code1.ccode=Left(code.ccode , 4) and code2.ccode=Left(code.ccode , 6)

分享到： 更多