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

>
>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