17,088
社区成员
发帖
与我相关
我的任务
分享
--SQL 1
SELECT account_id,address1,address2
FROM ADDRESSREFERENCE ADDRRF
LEFT JOIN ADDRESS ADDR
ON ADDRRF .ADDRESSID = ADDR. ADDRESSID
WHERE ADDRRF. ADDRESSTYPEID = 10
AND ADDRRF .ENTITYID = 3 ;
SELECT account_id,address1,address2 frin
(SELECT * FROM ADDRESSREFERENCE WHERE ADDRESSTYPEID = 10 AND ENTITYID =3 ) ADDRRF
LEFT JOIN ADDRESS ADDR ON ADDRRF.ADDRESSID = ADDR. ADDRESSID ;