I'm making money lending system. In my database there are two mysql tables which are custormer AND income. All custormer info stored in custormer table. When I give loans these loan details stored in loan table. After I received loan amount from custormers(daily payments) these records stored in income table.
What I want is,
Filter who are not give there daily installement today.
My tables are look like,
custormer table
custormer_id | custormer name
income table
custormer_id | loan_id | date
සශික
Recommended Answers
Jump to PostI think this will work (not tested). The important part is the inner select that returns all customer who DO have a record made against today's date and then you want to select the customers that are not in that list.
SELECT c.*, i.* FROM customer c …
Jump to PostIf you want but you implied you wanted today's transaction and NOW() gives you the current date. It's just simplier than passing in a variable you don't need.
If you wanted to check for a particular date then, yes, you can pass in whatever date you need.
All 5 Replies
hericles
289
Master Poster
Featured Poster
සශික
hericles
289
Master Poster
Featured Poster
සශික
hericles
289
Master Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.