mysql - 获得非付费成员(member)

Question

我有一个成员表

 member_Id
 member_Firstname

另一张表Paymentschedules

  paymentschedule_Id
  member_Id
  paymentschedule_amountdue values(100 rs,200rs)
  paymentschedule_amonutpaid values (30 rs,40 rs)
  paymentschedule_ActualDatetobepaid  values(2011-02-03,2011-02-01,2011-03-01)
  paymentschedule_ datepaid  values like(2011-09-12,2011-08-10,2011-11-12,2010-08-01)

我的问题是，考虑到这些值“ActualDatetobepaid”和“amonutpaid”以及“amountdue”和“datepaid”，我能否获得截至“今天”的成员(member)名字

谁能帮忙解决这个问题

Answer 1

您的最后一个请求“添加 7 天”通过向 J0HN 的解决方案添加 7 天得到解决:

SELECT DISTINCT member_Firstname  
FROM member m 
  JOIN Paymentscedules p ON p.member_id = m.member_id 
WHERE DATE_ADD(paymentschedule_ActualDatetobepaid, INTERVAL 7 DAY)< NOW() 
  AND paymentschedule_amountdue > paymentschedule_amonutpaid