DECLARE @MinInstallments VARCHAR(100)
DECLARE @CustCNIC VARCHAR(100)
Select @CustCNIC =Customer_CNIC from Customer
SELECT @MinInstallments = MIN(Installment_No)
FROM Installments AS i
WHERE Loan_id IN
(SELECT Loan_id FROM Customer WHERE Customer_CNIC = @CustCNIC);
SELECT CASE i.Installment_no WHEN @MinInstallments THEN i.Loan_id ELSE '' END AS LOAN_ID,
'Customer_CNIC' = CASE WHEN i.Installment_no = @MinInstallMents THEN @CustCNIC ELSE ''END, i.Installment_no, i.Date, i.Amount
FROM Installments i, Loan l, Customer c
WHERE l.Loan_id = c.Loan_id and c.Loan_id = i.Loan_id and c.Customer_CNIC=
@CustCNIC ORDER BY l.Loan_id,i.Installment_no