Database Join - Right Join?












-2















I have two tables shown below



Table 1 :

Table 1



Table 2 :



Table 2



I am looking for a join that would result in a table like this



Result :

Result



Any help is highly appreciated










share|improve this question

























  • Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

    – philipxy
    Nov 14 '18 at 5:13








  • 2





    We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

    – Tim Biegeleisen
    Nov 14 '18 at 5:14






  • 1





    In addition to Tim's question - what rdbms are you using?

    – Mureinik
    Nov 14 '18 at 6:20











  • @ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

    – philipxy
    Nov 14 '18 at 7:05











  • provide the code that you have already tried. It is not clear how to answer this question

    – Nishil
    Nov 14 '18 at 8:53
















-2















I have two tables shown below



Table 1 :

Table 1



Table 2 :



Table 2



I am looking for a join that would result in a table like this



Result :

Result



Any help is highly appreciated










share|improve this question

























  • Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

    – philipxy
    Nov 14 '18 at 5:13








  • 2





    We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

    – Tim Biegeleisen
    Nov 14 '18 at 5:14






  • 1





    In addition to Tim's question - what rdbms are you using?

    – Mureinik
    Nov 14 '18 at 6:20











  • @ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

    – philipxy
    Nov 14 '18 at 7:05











  • provide the code that you have already tried. It is not clear how to answer this question

    – Nishil
    Nov 14 '18 at 8:53














-2












-2








-2








I have two tables shown below



Table 1 :

Table 1



Table 2 :



Table 2



I am looking for a join that would result in a table like this



Result :

Result



Any help is highly appreciated










share|improve this question
















I have two tables shown below



Table 1 :

Table 1



Table 2 :



Table 2



I am looking for a join that would result in a table like this



Result :

Result



Any help is highly appreciated







database join






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 14 '18 at 6:07









Zain Farooq

1,9872927




1,9872927










asked Nov 14 '18 at 5:10









Omkar KhareOmkar Khare

1




1













  • Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

    – philipxy
    Nov 14 '18 at 5:13








  • 2





    We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

    – Tim Biegeleisen
    Nov 14 '18 at 5:14






  • 1





    In addition to Tim's question - what rdbms are you using?

    – Mureinik
    Nov 14 '18 at 6:20











  • @ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

    – philipxy
    Nov 14 '18 at 7:05











  • provide the code that you have already tried. It is not clear how to answer this question

    – Nishil
    Nov 14 '18 at 8:53



















  • Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

    – philipxy
    Nov 14 '18 at 5:13








  • 2





    We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

    – Tim Biegeleisen
    Nov 14 '18 at 5:14






  • 1





    In addition to Tim's question - what rdbms are you using?

    – Mureinik
    Nov 14 '18 at 6:20











  • @ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

    – philipxy
    Nov 14 '18 at 7:05











  • provide the code that you have already tried. It is not clear how to answer this question

    – Nishil
    Nov 14 '18 at 8:53

















Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

– philipxy
Nov 14 '18 at 5:13







Hi. Please read & act on How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'. Show what parts you can do & explain how you are stuck. Minimal, Complete, and Verifiable example Now you are just asking us to do your homework for you. PS Please use text, not images/links, for text (including code, tables & ERDs). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. Use edit functions to inline, not links, if you have the rep--make your post self-contained.

– philipxy
Nov 14 '18 at 5:13






2




2





We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

– Tim Biegeleisen
Nov 14 '18 at 5:14





We can't really give you a query without knowing why the first record only selectively joins to one of the two phone number records. Unclear what you are asking here.

– Tim Biegeleisen
Nov 14 '18 at 5:14




1




1





In addition to Tim's question - what rdbms are you using?

– Mureinik
Nov 14 '18 at 6:20





In addition to Tim's question - what rdbms are you using?

– Mureinik
Nov 14 '18 at 6:20













@ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

– philipxy
Nov 14 '18 at 7:05





@ZainFarooq Please do not inline links inappropriately. See my comment above re using text whenever possible. Either replace a link to a table by code block formatted tabular text (which should simultaneously be code to create & initialize a table if the question should give a Minimal, Complete, and Verifiable example) or, much better, comment to tell the poster to do it. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted.

– philipxy
Nov 14 '18 at 7:05













provide the code that you have already tried. It is not clear how to answer this question

– Nishil
Nov 14 '18 at 8:53





provide the code that you have already tried. It is not clear how to answer this question

– Nishil
Nov 14 '18 at 8:53












1 Answer
1






active

oldest

votes


















0














You can do it using LEFT JOIN



SELECT t2.Employee_ID,t1.Name,t1.Id,t2.Area_Code,t2.Phone_Number FROM dbo.Table_2 t2 
LEFT JOIN dbo.Table_1 t1 ON t1.Employee_ID=t2.Employee_ID





share|improve this answer
























  • That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

    – philipxy
    Nov 14 '18 at 7:09











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%2f53293538%2fdatabase-join-right-join%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









0














You can do it using LEFT JOIN



SELECT t2.Employee_ID,t1.Name,t1.Id,t2.Area_Code,t2.Phone_Number FROM dbo.Table_2 t2 
LEFT JOIN dbo.Table_1 t1 ON t1.Employee_ID=t2.Employee_ID





share|improve this answer
























  • That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

    – philipxy
    Nov 14 '18 at 7:09
















0














You can do it using LEFT JOIN



SELECT t2.Employee_ID,t1.Name,t1.Id,t2.Area_Code,t2.Phone_Number FROM dbo.Table_2 t2 
LEFT JOIN dbo.Table_1 t1 ON t1.Employee_ID=t2.Employee_ID





share|improve this answer
























  • That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

    – philipxy
    Nov 14 '18 at 7:09














0












0








0







You can do it using LEFT JOIN



SELECT t2.Employee_ID,t1.Name,t1.Id,t2.Area_Code,t2.Phone_Number FROM dbo.Table_2 t2 
LEFT JOIN dbo.Table_1 t1 ON t1.Employee_ID=t2.Employee_ID





share|improve this answer













You can do it using LEFT JOIN



SELECT t2.Employee_ID,t1.Name,t1.Id,t2.Area_Code,t2.Phone_Number FROM dbo.Table_2 t2 
LEFT JOIN dbo.Table_1 t1 ON t1.Employee_ID=t2.Employee_ID






share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 14 '18 at 6:42









Sabir Al FatehSabir Al Fateh

96121021




96121021













  • That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

    – philipxy
    Nov 14 '18 at 7:09



















  • That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

    – philipxy
    Nov 14 '18 at 7:09

















That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

– philipxy
Nov 14 '18 at 7:09





That query does not give the requested result. See the comments on the question. PS This is unclear so should not be answered; it should be downvoted & close voted. When it's clear it will be a faq; it should be downvoted & close voted. If it weren't a faq or unclear it should be downvoted & closed for not having a Minimal, Complete, and Verifiable example--if it had one, you could have run your query & seen it was wrong.

– philipxy
Nov 14 '18 at 7:09


















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%2f53293538%2fdatabase-join-right-join%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

Florida Star v. B. J. F.

Danny Elfman

Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues