try following,
declare @Clientdetailtable(clid int, name varchar(50))declare @OrderDetail
table(clid INT, ordid INT,MasterOrderId INT)declare @InvoiceDetail
table(nvId INT, total NUMERIC(18,2),MasterOrderId INT)
insert into @Clientdetail values(1, 'abc')
insert into @Clientdetail values(2, 'xyz')
insert into @OrderDetail values(1, 10000 ,50)
insert into @OrderDetail values(2,10005, 51 )
insert into @OrderDetail values(1, 10005 ,50)
insert into @OrderDetail values(2,10009,52)
insert into @InvoiceDetail values(101,56.25,50)
insert into @InvoiceDetail values(102,35.25,51)
insert into @InvoiceDetail values(103,100.32,52)
SELECT C.clid, C.name ,SUM(I.total) AS TOTAL FROM @Clientdetail C
INNER JOIN @OrderDetail O ON C.clid =O.clid
INNER JOIN @InvoiceDetail I ON I.MasterOrderId = O.MasterOrderId
GROUP BY C.clid,C.name
