MySQL Forums
Forum List  »  Newbie

Re: Merging queries
Posted by: Wim Roffel
Date: March 11, 2020 04:28AM

I don't understand your answer. A JOIN would assume that I would join the answers of the two queries on some common field. What I want to do is making two queries on the same table (and thus producing the same set of fields) and then merging those two results into one. So if the first part returns 5 rows and the second part returns 11 rows I want 16 rows returned: the first 5 from the first query part and the others from the second.

Options: ReplyQuote


Subject
Written By
Posted
March 10, 2020 09:51AM
March 10, 2020 12:48PM
Re: Merging queries
March 11, 2020 04:28AM
March 11, 2020 05:55AM
March 11, 2020 06:26AM


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.