How to get join of two tables in mysql
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
add a comment |
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
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
add a comment |
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
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
mysql
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
add a comment |
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
add a comment |
1 Answer
1
active
oldest
votes
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
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
add a comment |
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%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
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
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
add a comment |
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
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
add a comment |
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
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
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
add a comment |
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
add a comment |
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.
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%2f54003905%2fhow-to-get-join-of-two-tables-in-mysql%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
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