I am having a small problem with a small mysql query... I want to make a list of: "WHO HAS NOT PAID THEIR MEMBERSHIP FEE".
I guess I could maybe solve this one myself, its not too hard ... I have one table with members MEMBERS ------------------------------------------ | MemberID | Name | etc..... One table with fee payments FEE_PAYMENTS ------------------------------------------ | MemberID | date | price | etc... Now: How would I make a query that would list all members that have not paid their fee? How would I make a query that would list all members that have paid their fee? I'm just too tired to think it out myself :) Forgive me :) ------------------------- Med vennlig hilsen, Torkil Johnsen [EMAIL PROTECTED] ------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
