Dear experts,
kindly help me to get data like below
from
Select customer_number [Customer Number],customer_Name [Customer Name],Collector [Collector],clrno [CLR No],Clrdate [CLR Date],commitment_amount [Commitment Amount]
,Commitment_Date [Commitment Date] ,Receipt_Date [Receipt Date]
From (
Select
cm.customer_number,cm.customer_name,c.name as Collector,h.header_id clrno,Format(h.creation_date ,'dd-MMM-yyyy') Clrdate,cml.commitment_amount
,Format(cml.commitment_date ,'dd-MMM-yyyy') Commitment_Date ,Format(cml.receipt_date ,'dd-MMM-yyyy') Receipt_Date
From CLRHdrs h
Inner join CustomerMasters cm on h.customer_id=cm.customer_id
Inner join ClrCommitmentLogs cml on h.header_id=cml.clr_id
inner join Collectors c on h.collector_id=c.collector_id
Where -- h.header_id=156000