Help with a join

[Dashley]

I have two tables
tbl1 = members M

memberID
Lastname
firstname

tbl2 = contributions C
memberid
contribdate
contribamt


want to select m.lastname. m.lastname from members M where they haven't made a contribution (c.contribdate) in the last 16 months, so that date would be since
2/01/2017 or close by.

Thanks

-dan

 

[Andrzejek]

[tt]SELECT Lastname, firstname
FROM tbl1
WHERE memberID NOT IN (
SELECT memberID of members who DID pay in last 16 month)
[/tt]


---- Andy

There is a great need for a sarcasm font.

 

[bborissov]

SELECT Members.*
FROM Members
LEFT JOIN Contributors ON Members.Id = Contributors.Id AND Contributors.contribdate >= DateAdd(mm, -16 GETDATE())
WHERE Contributors.Id IS NULL

NOT TESTED!!

Borislav Borissov
VFP9 SP2, SQL Server

 

[Dashley]

Ok Thanks I'm going to try and get back on this today. I'll let you both know how it goes

Thanks