SELECT *
INTO #SEMFEST_TABLE
FROM ((SELECT CUS_ACTIVITY_ID, MASTER_CUSTOMER_ID, SUB_CUSTOMER_ID,
SUBSYSTEM, ACTIVITY_DATE, ACTIVITY_CODE, ACTIVITY_SUBCODE,
ACTIVITY_TEXT, CALL_TYPE_CODE, CALL_TOPIC_CODE,
CALL_TOPIC_SUBCODE, STAFF_USER_ID, COMMENTS, MARKET_CODE, ADDOPER, ADDDATE
FROM CUS_ACTIVITY
WHERE (ACTIVITY_CODE = 'CONTACTTRACKING') AND
(CALL_TOPIC_CODE = 'fest_callS') AND
(ACTIVITY_DATE > CONVERT(DATETIME, '2016-08-01 00:00:00', 102)))T1
LEFT OUTER JOIN
(SELECT PARENT_PRODUCT, SHIP_MASTER_CUSTOMER_ID, SHIP_SUB_CUSTOMER_ID,
ACTUAL_TOTAL_AMOUNT,
INVOICE_DATE AS REGISTRANT_DATE
FROM ORDER_DETAIL
WHERE (PARENT_PRODUCT = '17LV'))T2 ON T1.MASTER_CUSTOMER_ID = T2.SHIP_MASTER_CUSTOMER_ID)
---- I am trying to get total amount of a particular id.( There are multiple id's ) and get greatest invoice date??