Hi Sergey
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)
>

>
>>I have a table1 (PK=signout_id) and a table2 (PK=sgnout2_id,FK=signout_id)
>>
>>for each record in table1 I need the last record in table2 (max(insdttm))
>>
>>is the following sql statement reliable:
>>(VFP8 SP1)
>>
>>

>>SELECT table1.signout_id as id1,;
>>table1.claim_id,;
>>  MAX(table2.insdttm),table2.*;
>>  from signout table1;
>>   inner JOIN signout2 table2;
>>   ON table1.signout_id=table2.signout_id;
>>   GROUP BY 1,2
>>

>>
>>the table2.* data must belong to the table2 record with the highest insertdatetime (insdttm)
>>