Can any one help me to get a query to fulfill the following requirement.
Table Name: tblcustomer
Fields are: id, name, joining_date,prdid
Table Name: tblproducts
Fields are: prdid,prdname,cost,paymode
paymode is having details about payment mode: Monthly or Quartely or Halfyearly or Yearly
acts as a relationship between tblcustomer and tblproducts
I need to write a select query to find out list of customers eligible for the current month payment.