October 19th, 2012, 09:23 AM
I have 2 tables,
- Users with userId, userName
- Affiliations with id, affiliationId, affiliationStartDate, affiliationEndDate
How to find in a select all guys that haven't renew their affiliation before a certain date ?
So I'm looking for userName and max(affiliationEndDate) where max(affiliationEndDate) < '2012-11-01' ?
I'm using MySql 3.23.58
Yhanks for your help
October 19th, 2012, 12:12 PM
Something like this (not verified):
ON u.userid = a.id
max(a.affiliationEndDate) < '2012-11-01'
Originally Posted by ParisByNight
If you still use a software from 2003 I wonder how old your car is. Or if you work for NASA and have a really long procurement time.