17,140
社区成员




--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 ;