Pakki (8/27/2009)
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
Nearly the same error, now it gives me the below error
The multi-part identifier "tli.UpdateTime" could not be bound.
I think this is because tli.UpdateTime is actually coming from nested query in the JOIN?