select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. MemberID = FEE_PAYMENTS. MemberID;
assuming you have a field PAID, with values 0 or 1,or even YES or NO cheers Mark >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 --------------------------------------------------------------------- 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