Select to show clients that are not in another table

Question

What is the correct way to present my client table with the following clauses: Be more than 60 days without purchase, not in the Links table or have more than 20 days since the last call.

Fields table Client CNPJ, Client, Date Last Purchase

Campos Ligações CNPJ, Date Link.

Answer 1

What is recommended on this site is you always show what you tried to do and if any error occurred or the obtained result was not as expected.

This is not a site to just ask them to do something for you. Usually such a question is simply rejected.

Since you’re new, I’ll show you but make a tour on how to use this site.

Try:

SELECT Clientes.* FROM Clientes INNER JOIN Ligações ON (Cliente.CNPJ = Ligações.CNPJ)
WHERE (Cliente.Data_ultima_compra < DATE_SUB(CURRENT_DATE, 60 DAY))
    OR (Ligações.CNPJ IS NULL)
    OR (Ligações.Data_ligação IS NOT NULL AND Ligações.Data_ligação < DATE_SUB(CURRENT_DATE, 20 DAY));