MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Sorting joined table results chronologically to return most recent entry
Posted by: Peter Brawley
Date: September 24, 2018 08:38AM

The query does not aggregate, so Group By just arbitrary selects return values for every column except those Grouped By. So why in the world are you using Group By?

Did you try something like ...Order By key_id,key_name, Ifnull(ron.date_updated,'zzzzz')... ?

And why Left Join to Notes?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Sorting joined table results chronologically to return most recent entry
Shannon Whitty
September 24, 2018 12:57AM
Re: Sorting joined table results chronologically to return most recent entry
Peter Brawley
September 24, 2018 08:38AM
Re: Sorting joined table results chronologically to return most recent entry
Shannon Whitty
September 24, 2018 08:14PM
Re: Sorting joined table results chronologically to return most recent entry
Peter Brawley
September 26, 2018 08:54AM


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.