SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table calender  (id int, [date] date)
Insert into calender values(1,'2022-12-13')
Insert into calender values(2,'2022-12-14')
Insert into calender values(3,'2022-12-15')
Insert into calender values(4,'2022-12-16')
Insert into calender values(5,'2022-12-17')
Insert into calender values(6,'2022-12-18')
Create table Kuber_reports (id int,  trans_Date	date, net_Value int,client_code varchar(100))     
Insert into Kuber_reports values(1,'2022-12-14',100,'GBN10001')
Insert into Kuber_reports values(2,'2022-12-14',-50,'GBN10001')
Insert into Kuber_reports values(3,'2022-12-14',100,'GBN10001')
Insert into Kuber_reports values(4,'2022-12-15',500,'GBN10001')
Insert into Kuber_reports values(5,'2022-12-16',1000,'GBN10001')
Create table trade_details (id int,  trade_Date	date, net_pnl int,client_code varchar(100))  
Insert into trade_details values(1,'2022-12-14',100,'GBN10001')
Insert into trade_details values(2,'2022-12-14',-50,'GBN10001')
Insert into trade_details values(3,'2022-12-14',100,'GBN10001')
Insert into trade_details values(4,'2022-12-15',500,'GBN10001')
Insert into trade_details values(5,'2022-12-16',900,'GBN10001')

16 rows affected

date	client_code	net_value	net_pnl	differnce
2022-12-14	GBN10001	150	150	0
2022-12-15	GBN10001	500	500	0
2022-12-16	GBN10001	1000	900	-100
2022-12-17	null	null	null	null
2022-12-18	null	null	null	null
2022-12-13	null	null	null	null