>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
selectID,a,b,c,d
, (SELECTsum(value) FROM Indet WHERE INID = In.ID) astotalfromInwhereID='54321'
this in VFP9:
selectID,a,b,c,d ;
, (SELECTsum(value) FROM Indet WHERE INID = In.ID) astotal ;
fromIn ;
whereID='54321'