MySQL Forums
Forum List  »  Newbie

Re: MySQL CONCAT and INNER JOIN - Adding another child table
Posted by: Peter Brawley
Date: July 09, 2021 08:58AM

You mean to append the rows from the additional table? Just add another union clause.

The query as shown just happens to follow the desired row ordering, but isn't guaranteed to do so---ordering is inherently arbitrary unless specified, so you need to analyse the query for desired ordering and add that Order By clause.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL CONCAT and INNER JOIN - Adding another child table
July 09, 2021 08:58AM


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.