Depends on how the fee paymnents are defined. At its simplest: SELECT Members..Name FROM Members WHERE NOT(Members.MemberID = FEE_PAYMENTS.MenmbersID)
would select members that have no fee payment records. You could build on it from there... For the mySQL gurus, sorry about the syntax guys, I've been with Access to long but I'm coming over quickly :-) Pierre Torkil Johnsen wrote: > 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 > > > > -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 "If it feels good, do it!" --------------------------------------------------------------------- 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
