Re: select max date in Inner Join
I have solved the query
Thank you for your kind concern, i really appreciate it
The final query is::
SELECT users.userid, users.Fname, users.Sname, users.LastUpdated, useraddress.Address1, useraddress.Address2, useraddress.City, useraddress.Country, useraddress.PostalCode, useraddress.HomeNo, useraddress.MobileNo, p.Q
FROM users
INNER JOIN useraddress ON useraddress.Userid = users.Userid
INNER JOIN (
SELECT userid, MAX( last_updated ) AS Q
FROM invoice
GROUP BY invoice.userid
) AS p ON p.userid = users.Userid
AND TO_DAYS( p.Q ) >= TO_DAYS( '2010-6-21' )
AND TO_DAYS( p.Q ) <= TO_DAYS( '2010-6-25' )
GROUP BY users.Fname
ORDER BY `users`.`Fname` ASC