How to write query similar to this with codeigniter active record?

[eluser]Unknown[/eluser]
this is the mysql query i want to write with codeigniter

Code:

SELECT r.reciept_no,r.loan_no,r.amount_paid,c.mem_name  
FROM receipts r, customer c
WHERE r.loan_no = c.loan_no AND reciept_no = '$receipt_id'

any help would be great

Regards