>Thanks for your answer. I tried but it didn't work for me.
>
>Is this sintaxe valid for Visual FoxPro8?
>Is there an equivalent one to SQL SERVER
>
>Best Regards

This must work on SQL Server

select ID,a,b,c,d
, (SELECT sum(value) FROM  Indet WHERE INID = In.ID) as total
   from In
   where  ID='54321'

this in VFP9:

select ID,a,b,c,d ;
, (SELECT sum(value) FROM  Indet WHERE INID = In.ID) as total ;
   from In ;
   where  ID='54321'