I have following mysql tables.
1. members
----------
|id |name|
----------
|001|aaa |
|002|bbb |
|003|ccc |
|004|ddd |
----------
2. membershipfees
----------------
|id |date |
----------------
|001|2012-01-01|
|002|2012-01-01|
----------------
I want to show list of the members who not paid the fees for the current month. My php code is,
SELECT Members.id, Members.Name FROM Members
LEFT JOIN MembershipFees
ON Members.id = MembersipFees.id
WHERE DATE_FORMAT(MembershipFees.Date, '%Y%m') <> DATE_FORMAT(NOW(), '%Y%m')
ORDER BY Members.id ASC
But it shows 0 rows. Any suggestions please.