Hi

Suppose I have an invoice(In) and invoice details(INdet) and I need some properties from the invoice and the total of the invoice from the invoice details

The SQL Statement should be

select In.ID,In.a,In.b,In.c,In.d,sum(InDet.value) as 'total' from In,Indet where In.ID=Indet.INID and In.ID='54321' group by id,a,b,c,d

Is there a better way to do this?

TIA