I have Two Tables Fee and Bill_Fee . Bill_Fee has been made to resolve the many to many relationship between Fee and Bill.
Fee
----------
id
amt
student_id
Bill_Fee
----------
fee_id
bill_id
First the Fee
table should be selected with the help of student_id
and then i need to MINUS
as a set(A={1,2,4,6,8} B={1,2,6,8,9,0}) A-B={4}
Like this so that if the fee_id
exists in bill fee
the details of those fees should not be extracted. and Those fee_id
which are not in Bill
should be extracted