How to get join of two tables in mysql












-2















I have two MySQL tables single_match_master and team_master.



single_match_master columns => match_id, team1_id, team2_id, team1_score, team2_score



team_master columns => team_id, team_name



I want to select match_id and the respective name of teams from the team_master table.



here is the query which i have written it gives empty set as result;



select  a.match_id,a.team1_id,a.team2_id,a.team1_score,
a.team2_score,a.status,
b.team_name
from single_match_master a,team_master b
where a.team1_id=b.team_id
and a.team2_id=b.team_id;









share|improve this question

























  • So can you show us the amended SQL with a JOIN in it that you have tried to write?

    – RiggsFolly
    Jan 2 at 9:28











  • I have added the query which I have tried.

    – Poison8
    Jan 2 at 9:30













  • But that does not contain a JOIN

    – RiggsFolly
    Jan 2 at 9:31
















-2















I have two MySQL tables single_match_master and team_master.



single_match_master columns => match_id, team1_id, team2_id, team1_score, team2_score



team_master columns => team_id, team_name



I want to select match_id and the respective name of teams from the team_master table.



here is the query which i have written it gives empty set as result;



select  a.match_id,a.team1_id,a.team2_id,a.team1_score,
a.team2_score,a.status,
b.team_name
from single_match_master a,team_master b
where a.team1_id=b.team_id
and a.team2_id=b.team_id;









share|improve this question

























  • So can you show us the amended SQL with a JOIN in it that you have tried to write?

    – RiggsFolly
    Jan 2 at 9:28











  • I have added the query which I have tried.

    – Poison8
    Jan 2 at 9:30













  • But that does not contain a JOIN

    – RiggsFolly
    Jan 2 at 9:31














-2












-2








-2








I have two MySQL tables single_match_master and team_master.



single_match_master columns => match_id, team1_id, team2_id, team1_score, team2_score



team_master columns => team_id, team_name



I want to select match_id and the respective name of teams from the team_master table.



here is the query which i have written it gives empty set as result;



select  a.match_id,a.team1_id,a.team2_id,a.team1_score,
a.team2_score,a.status,
b.team_name
from single_match_master a,team_master b
where a.team1_id=b.team_id
and a.team2_id=b.team_id;









share|improve this question
















I have two MySQL tables single_match_master and team_master.



single_match_master columns => match_id, team1_id, team2_id, team1_score, team2_score



team_master columns => team_id, team_name



I want to select match_id and the respective name of teams from the team_master table.



here is the query which i have written it gives empty set as result;



select  a.match_id,a.team1_id,a.team2_id,a.team1_score,
a.team2_score,a.status,
b.team_name
from single_match_master a,team_master b
where a.team1_id=b.team_id
and a.team2_id=b.team_id;






mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 2 at 9:28









RiggsFolly

71.4k1866113




71.4k1866113










asked Jan 2 at 9:26









Poison8Poison8

77




77













  • So can you show us the amended SQL with a JOIN in it that you have tried to write?

    – RiggsFolly
    Jan 2 at 9:28











  • I have added the query which I have tried.

    – Poison8
    Jan 2 at 9:30













  • But that does not contain a JOIN

    – RiggsFolly
    Jan 2 at 9:31



















  • So can you show us the amended SQL with a JOIN in it that you have tried to write?

    – RiggsFolly
    Jan 2 at 9:28











  • I have added the query which I have tried.

    – Poison8
    Jan 2 at 9:30













  • But that does not contain a JOIN

    – RiggsFolly
    Jan 2 at 9:31

















So can you show us the amended SQL with a JOIN in it that you have tried to write?

– RiggsFolly
Jan 2 at 9:28





So can you show us the amended SQL with a JOIN in it that you have tried to write?

– RiggsFolly
Jan 2 at 9:28













I have added the query which I have tried.

– Poison8
Jan 2 at 9:30







I have added the query which I have tried.

– Poison8
Jan 2 at 9:30















But that does not contain a JOIN

– RiggsFolly
Jan 2 at 9:31





But that does not contain a JOIN

– RiggsFolly
Jan 2 at 9:31












1 Answer
1






active

oldest

votes


















2














You can try below - using join of multiple instance of team_master table



select 
a.match_id,a.team1_id,a.team2_id,a.team1_score,a.team2_score,
a.status,b.team_name as team1name, b1.team_name as team2name
from
single_match_master a inner join team_master b
on a.team1_id=b.team_id inner join team_master b1
on a.team2_id=b1.team_id





share|improve this answer


























  • it still gives me an empty set

    – Poison8
    Jan 2 at 9:35






  • 1





    yea. It works now, Thanks mate :)

    – Poison8
    Jan 2 at 9:41













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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003905%2fhow-to-get-join-of-two-tables-in-mysql%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














You can try below - using join of multiple instance of team_master table



select 
a.match_id,a.team1_id,a.team2_id,a.team1_score,a.team2_score,
a.status,b.team_name as team1name, b1.team_name as team2name
from
single_match_master a inner join team_master b
on a.team1_id=b.team_id inner join team_master b1
on a.team2_id=b1.team_id





share|improve this answer


























  • it still gives me an empty set

    – Poison8
    Jan 2 at 9:35






  • 1





    yea. It works now, Thanks mate :)

    – Poison8
    Jan 2 at 9:41


















2














You can try below - using join of multiple instance of team_master table



select 
a.match_id,a.team1_id,a.team2_id,a.team1_score,a.team2_score,
a.status,b.team_name as team1name, b1.team_name as team2name
from
single_match_master a inner join team_master b
on a.team1_id=b.team_id inner join team_master b1
on a.team2_id=b1.team_id





share|improve this answer


























  • it still gives me an empty set

    – Poison8
    Jan 2 at 9:35






  • 1





    yea. It works now, Thanks mate :)

    – Poison8
    Jan 2 at 9:41
















2












2








2







You can try below - using join of multiple instance of team_master table



select 
a.match_id,a.team1_id,a.team2_id,a.team1_score,a.team2_score,
a.status,b.team_name as team1name, b1.team_name as team2name
from
single_match_master a inner join team_master b
on a.team1_id=b.team_id inner join team_master b1
on a.team2_id=b1.team_id





share|improve this answer















You can try below - using join of multiple instance of team_master table



select 
a.match_id,a.team1_id,a.team2_id,a.team1_score,a.team2_score,
a.status,b.team_name as team1name, b1.team_name as team2name
from
single_match_master a inner join team_master b
on a.team1_id=b.team_id inner join team_master b1
on a.team2_id=b1.team_id






share|improve this answer














share|improve this answer



share|improve this answer








edited Jan 2 at 9:37

























answered Jan 2 at 9:29









fa06fa06

15.9k21018




15.9k21018













  • it still gives me an empty set

    – Poison8
    Jan 2 at 9:35






  • 1





    yea. It works now, Thanks mate :)

    – Poison8
    Jan 2 at 9:41





















  • it still gives me an empty set

    – Poison8
    Jan 2 at 9:35






  • 1





    yea. It works now, Thanks mate :)

    – Poison8
    Jan 2 at 9:41



















it still gives me an empty set

– Poison8
Jan 2 at 9:35





it still gives me an empty set

– Poison8
Jan 2 at 9:35




1




1





yea. It works now, Thanks mate :)

– Poison8
Jan 2 at 9:41







yea. It works now, Thanks mate :)

– Poison8
Jan 2 at 9:41






















draft saved

draft discarded




















































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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003905%2fhow-to-get-join-of-two-tables-in-mysql%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas