MySQL Forums
Forum List  »  PHP

Re: Trying to do Inner Join, plus DISTINCT on a column
Posted by: Peter Brawley
Date: November 12, 2019 12:00PM

With Group By, all Select columns that neither aggregate nor are Grouped By return arbitrary results, so your query as written returns unreliable results.

By "distinct row" you mean what, specifically when there are multiple message rows for one id, what do you want the query result to look like?

Options: ReplyQuote


Subject
Written By
Posted
Re: Trying to do Inner Join, plus DISTINCT on a column
November 12, 2019 12:00PM


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.