access 操作符丢失？高手快来啊，left outer join查询

[deng520159]

select R_ID,R_Date,R_TimeStamp,R_IsIncome,R_P_ID,P_Name,R_Money,R_OutAccount,A.CardCode,R_InAccount,B.CardCode,R_Handle,R_Memo
from Records left outer join Persons on Records.R_P_ID=Persons.P_ID
left outer join Accounts as A on Records.R_OutAccount=A.A_ID
left outer join Accounts as B on Records.R_InAccount=B.A_ID

[北京]sky(375235329) 11:07:53
说操作符丢失
[北京]sky(375235329) 11:08:07
在from处，

那位知道这样R_OutAccount R_InAccount 这两都是id,但又有字段和他们关联怎么查出来？？就是查询A.cardcode,B.cardcode,

[mzjmicrosoft]

视图

然后再查视图加条件

不行再把视图设计成"视图"

然后再查

直到你解决问题

[tjficcbw]

先说表结构，再说你的意思，这样没头没脑说不明白

[huangheguyun]

先说表结构，再说你的意思,出现的问题，不能让我们在这乱猜。

[mayonglong]

Up~

[deng520159]

dsaf

[deng520159]

其已经解决了问题感谢上面兄弟 ，是因为access 没有基于标准sql ，外联一下要加个括号，再和下一个外联

<select id="GetRecordByID" resultMap="RecordResult" parameterClass="Record" >
SELECT R_ID, R_Date, R_TimeStamp, R_IsIncome, R_P_ID, P_Name, R_Money, R_OutAccount, A.A_CardCode as C1,A.A_BankName as B1,A.A_CardUserName as U1 , R_InAccount, B.A_CardCode as C2,B.A_BankName as B2,B.A_CardUserName as U2, R_Handle, R_Memo
FROM
((Persons INNER JOIN Records ON Persons.P_ID=Records.R_P_ID)
LEFT JOIN Accounts AS A ON Records.R_OutAccount=A.A_ID)
LEFT JOIN Accounts AS B ON Records.R_InAccount=B.A_ID;
where R_ID=#ID#
</select>

[deng520159]

persons(P_ID,P_Tel,P_Name,P_Memo)
Records(R_ID, R_Date, R_TimeStamp, R_IsIncome, R_P_ID, P_Name, R_Money, R_OutAccount, R_InAccount, R_Handle, R_Memo)
Accounts(A_ID,A_P_ID,A_BankName,A_CardCode,A_CardUserName,A_Memo)