Give some other table name as the alias for the nested table (lets say tli2)

U mean to say this is also giving the same error?

SELECT c.claimnumber AS claimnumber,

tli1.UpdateTime as TranLineItemUT,

FROM cc_claim c

--Transaction Line Item

left outer join (select MAX(tli1.ID) as ID , t1.ClaimID as CLAIM_ID, MAX(tli1.UpdateTime) as UpdateTime

from cc_transactionlineitem tli1

inner join cc_transaction t1 ON t1.id = tli1.transactionid

group by t1.ClaimID) tli2 ON c.ID = tli2.CLAIM_ID