select a.loanid, d.itemid, u.userid, a.enddttime, u.companyid,d.interesttype from tbl_user_contact u, tbl_loan_accepted a, tbl_loan_details d where u.userid = d.userid and d.itemid = a.itemid and d.amount > 100000 ;