SELECT course_registration.stud_id,
batch_course_registration.bcr_batch_id,
bill_file.cr_bill_no,
receipt_file.bill_no,
bill_file.bill_dt,
bill_file.bill_pend_Amt,
bill_file.bill_active ,
receipt_file.rcpt_no,
receipt_file.rcpt_dt, Amt
FROM course_registration cr
inner join batch_course_registration bcr on cr.cr_bill_no = crb.cr_bill_no
inner join bill_file bf on bf.cr_bill_no = crb.cr_bill_no
inner join receipt_file rf on rf.bill_no = bf.bill_no
WHERE cr.stud_id = <write here student id>
By the way what was issue while you doing it?