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,
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,
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>
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)