You're welcome. The easiest way to overcome it is to SET ENGINEBHAVIR 80 and keep it this way. :)

>Thanks a lot. I still have not overcome enginbehavior70-itis <s>
>
>Peter
>
>
>>Hi Peter,
>>
>>Your select wouldn't run with SET ENGINEBHAVIR 80 because you didn't define from which records data for table2 columns should come. Try

SELECT t1.signout_id AS id1,;
>>		t1.claim_id,;
>>		t2.* ;
>>	FROM signout t1;
>>	JOIN signout2 t2;
>>	ON t1.signout_id = t2.signout_id
>>	WHERE t2.insdttm IN ( ;
>>		SELECT MAX(t2.insdttm) FROM signout2 t22 ;
>>			WHERE t22.signout_id = t2.signout_id)
>>