MYSQL - Master on one row and loop through details rows
I am trying to execute a query within MySQL to have the master row on one line and the looped details rows after the master row.
The primary key on the master table is id_post and the foreign key on the details table is idpost_comment. I have tried LEFT JOIN, RIGHT JOIN, INNER JOIN, but they all combine the data on one row.
I have drafted a sample of what I am trying to achieve in the link below:
This is what I am trying to archive:
SELECT id_post AS ID1, date_post AS date1, desc_post FROM posts_master AS t1
UNION ALL
SELECT idpost_comment, date_comment AS date2, description_comment FROM posts_details AS t2
ORDER BY date1
But I need to join the two tables with a ON statement?
mysql loops
edited Nov 12 at 11:29
user6910411
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
add a comment |
I am trying to execute a query within MySQL to have the master row on one line and the looped details rows after the master row.
The primary key on the master table is id_post and the foreign key on the details table is idpost_comment. I have tried LEFT JOIN, RIGHT JOIN, INNER JOIN, but they all combine the data on one row.
I have drafted a sample of what I am trying to achieve in the link below:
This is what I am trying to archive:
SELECT id_post AS ID1, date_post AS date1, desc_post FROM posts_master AS t1
UNION ALL
SELECT idpost_comment, date_comment AS date2, description_comment FROM posts_details AS t2
ORDER BY date1
But I need to join the two tables with a ON statement?
mysql loops
edited Nov 12 at 11:29
user6910411
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
1
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07
add a comment |
I am trying to execute a query within MySQL to have the master row on one line and the looped details rows after the master row.
The primary key on the master table is id_post and the foreign key on the details table is idpost_comment. I have tried LEFT JOIN, RIGHT JOIN, INNER JOIN, but they all combine the data on one row.
I have drafted a sample of what I am trying to achieve in the link below:
This is what I am trying to archive:
SELECT id_post AS ID1, date_post AS date1, desc_post FROM posts_master AS t1
UNION ALL
SELECT idpost_comment, date_comment AS date2, description_comment FROM posts_details AS t2
ORDER BY date1
But I need to join the two tables with a ON statement?
mysql loops
edited Nov 12 at 11:29
user6910411
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
I am trying to execute a query within MySQL to have the master row on one line and the looped details rows after the master row.
The primary key on the master table is id_post and the foreign key on the details table is idpost_comment. I have tried LEFT JOIN, RIGHT JOIN, INNER JOIN, but they all combine the data on one row.
I have drafted a sample of what I am trying to achieve in the link below:
This is what I am trying to archive:
SELECT id_post AS ID1, date_post AS date1, desc_post FROM posts_master AS t1
UNION ALL
SELECT idpost_comment, date_comment AS date2, description_comment FROM posts_details AS t2
ORDER BY date1
But I need to join the two tables with a ON statement?
mysql loops
mysql loops
edited Nov 12 at 11:29
user6910411
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
edited Nov 12 at 11:29
user6910411
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
edited Nov 12 at 11:29
user6910411
32.5k86995
edited Nov 12 at 11:29
user6910411
32.5k86995
edited Nov 12 at 11:29
user6910411
32.5k86995
32.5k86995
asked Nov 11 at 9:03
Code-Turtle
11
asked Nov 11 at 9:03
Code-Turtle
11
asked Nov 11 at 9:03
Code-Turtle
11
11
1
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07
add a comment |
1
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07
1
1
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247238%2fmysql-master-on-one-row-and-loop-through-details-rows%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247238%2fmysql-master-on-one-row-and-loop-through-details-rows%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 11 at 9:07