改了看下，应该是select字段是子查询的问题吧。还有个问题就是GL_DOCFREE1都没有用到字段left join 它干嘛？

SELECT A.ACCOUNTCODE,A.PERIODV,A.NOV,A.YEARV,A.LOCALCREDITAMOUNT,A.LOCALDEBITAMOUNT,A.EXPLANATION,A.PK_VOUCHERTYPEV,A.ASSID,A.PK_DETAIL,A.PK_ACCOUNTINGBOOK,A.PK_ORG,A.PK_ACCASOA,

 B.NAME AS 财务组织,

 C.NAME AS 凭证类别,

 D.FILE_ID AS 数据交换平台传递编号

FROM GL_DETAIL A

LEFT JOIN (SELECT B.PK_CORP,B.NAME FROM ORG_CORP B WHERE B.NAME='A公司')B ON B.PK_CORP=A.PK_ORG

LEFT JOIN (SELECT C.PK_VOUCHERTYPE,C.NAME from  BD_VOUCHERTYPE C )C ON C.PK_VOUCHERTYPE=A.PK_VOUCHERTYPEV

LEFT JOIN (SELECT D.PK_DETAIL,D.FILE_ID from V_GL_DETAIL D)D ON D.PK_DETAIL= A.PK_DETAIL

LEFT JOIN GL_DOCFREE1 E WHERE  A.ASSID=E.ASSID

最后的where  改成  on

-----------------

改了一下sql,拿数据跑一下看看

SELECT

ACCOUNTCODE,

PERIODV,

NOV,

YEARV,

LOCALCREDITAMOUNT,

LOCALDEBITAMOUNT,

EXPLANATION,

PK_VOUCHERTYPEV,

A.ASSID,

PK_DETAIL,

PK_ACCOUNTINGBOOK,

PK_ORG,

PK_ACCASOA,

( SELECT NAME FROM ORG_CORP A LEFT JOIN GL_DETAIL B ON A.PK_CORP = B.PK_ORG WHERE NAME = 'A公司' ) AS 财务组织,

( SELECT NAME FROM BD_VOUCHERTYPE A LEFT JOIN GL_DETAIL B ON A.PK_VOUCHERTYPEV= B.PK_VOUCHERTYPE ) AS 凭证类别,

( SELECT FILE_ID FROM V_GL_DETAIL A LEFT JOIN GL_DETAIL B ON A.PK_DETAIL= B.PK_DETAIL ) AS 数据交换平台传递编号 

FROM

GL_DETAIL A

LEFT JOIN GL_DOCFREE1 B ON A.ASSID= B.ASSID