條件是A,B兩表，A中有ID，同一ID有兩值，以它更新時(shí)間為區(qū)別，現(xiàn)在要取的是最新的ID那個(gè)值，并且關(guān)聯(lián)到B中的一屬性。SQL不太好，留在這里以后繼續(xù)學(xué)習(xí)
SELECT? Distinct tab1.CUSTOMER_ID, ACV.LAST_NAME,tab1.maxla
?? FROM AR_CONTACTS_V ACV,
??????? (SELECT RC.CUSTOMER_ID CUSTOMER_ID, MAX(ACV.LAST_UPDATE_DATE) MAXLA
?????????? FROM AR_CONTACTS_V ACV, RA_CUSTOMERS RC
????????? WHERE ACV.CUSTOMER_ID(+) = RC.CUSTOMER_ID
????????? GROUP BY RC.CUSTOMER_ID) TAB1
? WHERE ACV.CUSTOMER_ID(+) = TAB1.CUSTOMER_ID
??? AND ACV.LAST_UPDATE_DATE(+) = TAB1.MAXLA