help with sql syntax

[h2mhd]

hi

i have two tables

client:
idclient
name
adress
....

invoice
idinvoice
dateinvoice
idclient
...


what i want to do is make an sql that will give me all the clients that does not have an since 90 days and more

is there a simple way to do that, im a little bit rusted in these syntax.

tahnks a lot

 

[Golom]

Assuming that there may be multiple invoices for a client ...

If you just want the idclient field

Select I.idclient
From invoice As I
Group By I.idclient
Having MAX(I.dateinvoice) <= Date() - 90

If you want fields from the client table

Select C.idclient, C.Name, C.Adress

From client As C INNER JOIN 

(Select I.idclient
 From invoice As I
 Group By I.idclient
 Having MAX(I.dateinvoice) <= Date() - 90) As X

ON X.idclient = C.idclient