Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by fickbrayne
-
JOIN syntax (INNER JOIN), self join
OH! The bad-old-version problem. Oy vay. Thanks for your help and comments everyone. Sorry I didn't post this morning - deep snow here in Western Massachusetts. swampBoogie, you are right. I am using MySQL 4.0.18 and as this is on phpwebhosting.com I don't think I'll get the upgrade in a...- fickbrayne
- Post #8
- Forum: MySQL
-
JOIN syntax (INNER JOIN), self join
I want to find the most recent purchase for each customer(see below) and I tried: SELECT A.* FROM mytable A INNER JOIN ( SELECT full_name, Max(entered_when) AS entered_when FROM mytable GROUP BY full_name ) M ON A.full_name=M.full_name AND A.entered_when=M.entered_when ; I got a syntax error...- fickbrayne
- Thread
- Replies: 9
- Forum: MySQL
