Início / user-78640

humphrey's questions

Martin Hope
humphrey
Asked: 2017-06-25 06:38:09 +0800 CST
  • 2

Estou buscando dados de duas tabelas, membros e taxas. Gostaria de selecionar apenas os membros que não fizeram nenhum depósito este mês. Isto é o que eu tentei, mas os resultados não são o que eu pretendo obter. Qualquer ajuda será apreciada . Estou usando mysql.

SELECT
    members.memberid, 
    members.companyid, 
    members.name, 
    members.initials, 
    members.surname, 
    members.datejoined,
    members.usercode, 
    members.address, 
    members.cell, 
    members.pic, 
    members.idnumber, members.rank, 
    members.address2,
    fees.feestype,fees.amountpaid,
    fees.companyid,fees.paiddate,
    fees.usercode
FROM 
    members
    INNER JOIN fees
        ON members.memberid = fees.memberid
WHERE 
        MONTH(fees.paiddate) < MONTH(CURDATE())
    AND YEAR(fees.paiddate)  < YEAR(CURDATE())
mysql