trying to get the member details does not paid by due day

I have a

      member table
           member_Id
           member_lastname
           member_firstname

      membership ta开发者_StackOverflow中文版ble
            membership_id
            member_id
            membershipoption_Id
            membership_startdate  (values like 2011-09-08,2011-05-06,2011-08-09)
            membership_enddate     (values like 2012-04-05 , 2013-09-08,2014-09-08)
            membership_due day   ( values like only day not including month and year  like 01,21,19,14)

        membershipoption table
                 membershipoption_Id
                 membershipoption_name ( values like 12 months,36 months,24 months)
                 membershipoption_period(values like month ,year)
                 membershipoption_length(12months , 2 years like...)
                 membership_chargeperperiod(53.00,400.00,100.00)

is it possible to get the memberdetails who has not paid the money by due day by using above columns ... can any hav idea about this.. many thanks....

---

No, it is not possible. There is no place in that schema to store when, or if, anyone has paid. Therefore it's not possible to see who has not paid.

---

You need another table with the payment details. With the information posted, you know when somebody has to pay, but you don't have the information when somebody really payd. Like Kieren Johnstone already posted, it is not possible with that information.