MySQL Forums
Forum List  »  Newbie

Re: SQL Question - Join Full example given
Posted by: Felix Geerinckx
Date: May 27, 2005 12:46PM

Matt S wrote:
> Yes, the objective is to get all of the clients
> information in one row (one row per client) using
> the address with the highest addressid and the
> count with the hightest countid. I actually have
> more joins, but if I get a working soltion for the
> above problem, I am pretty sure I can get things
> working.

Maybe of interest: http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: SQL Question - Join Full example given
May 27, 2005 12:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.