i have 12 record. i want to show Amount,date and installment no 12 times in a sequence but loan id only one time in a row. help me with this.
thanX in advance
Select c.Loan_id,i.Installment_no,i.Date,i.Amount from Customer c,Installments i,Loan l where l.Loan_id=c.Loan_id and c.Loan_id=i.Loan_id;