{"id":20624,"date":"2022-11-10T07:41:36","date_gmt":"2022-11-10T02:11:36","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/"},"modified":"2022-11-10T07:41:36","modified_gmt":"2022-11-10T02:11:36","slug":"solved-joining-2-tables-and-save-into-third-with-duplicates-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/","title":{"rendered":"[Solved] joining 2 tables and save into third with duplicates [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

A Student with just one Professor:<\/strong><\/p>\n

A third table is not necessary, just add that foreign key (idp = Professor ID) in the Student Table so that you can do:<\/p>\n

SELECT * FROM Student \n    JOIN Professor ON Student.idp = Professor.idp \n    WHERE Professor.Name=\"Jon\" \n<\/code><\/pre>\n
and this way you will get all the students who have Jon as their Professor.<\/p>\n
A Student multiple professors<\/strong><\/p>\n
In case that a student have multiple professors. For sure you will need that third table then. Somethin like this:<\/p>\n
Student_Professor {StudentID, ProfessorID} \/\/ Compound key\n<\/code><\/pre>\n
Another way to create that third table would be:<\/p>\n
Student_Professor {StudentProfessorID, StudentID, ProfessorID} \n<\/code><\/pre>\n
where StudentProfessorID is your primary key and the rest foreign keys.. The advantage with this case is that you will only have to deal with one primary key instead of the compound one.<\/p>\n
Query<\/strong><\/p>\n
Assuming that the third table is like this: Student_Professor {StudentID, ProfessorID}<\/p>\n
We could use:<\/p>\n
SELECT * FROM Student_Professor \n    JOIN Student ON Student.StudentID = Student_Professor.StudentID\n    JOIN Professor ON Professor.ProfessorID = Student_Professor.ProfessorID\nWHERE Professor.Name=\"Jon\" \n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            6<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved joining 2 tables and save into third with duplicates [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] A Student with just one Professor: A third table is not necessary, just add that foreign key (idp = Professor ID) in the Student Table so that you can do: SELECT * FROM Student JOIN Professor ON Student.idp = Professor.idp WHERE Professor.Name=”Jon” and this way you will get all the students who have Jon … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,341],"class_list":["post-20624","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-sql"],"yoast_head":"\n[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] A Student with just one Professor: A third table is not necessary, just add that foreign key (idp = Professor ID) in the Student Table so that you can do: SELECT * FROM Student JOIN Professor ON Student.idp = Professor.idp WHERE Professor.Name="Jon" and this way you will get all the students who have Jon ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-10T02:11:36+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] joining 2 tables and save into third with duplicates [closed]\",\"datePublished\":\"2022-11-10T02:11:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\"},\"wordCount\":148,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\",\"name\":\"[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-10T02:11:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] joining 2 tables and save into third with duplicates [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb","og_description":"[ad_1] A Student with just one Professor: A third table is not necessary, just add that foreign key (idp = Professor ID) in the Student Table so that you can do: SELECT * FROM Student JOIN Professor ON Student.idp = Professor.idp WHERE Professor.Name=\"Jon\" and this way you will get all the students who have Jon ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/","og_site_name":"JassWeb","article_published_time":"2022-11-10T02:11:36+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] joining 2 tables and save into third with duplicates [closed]","datePublished":"2022-11-10T02:11:36+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/"},"wordCount":148,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/","name":"[Solved] joining 2 tables and save into third with duplicates [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-10T02:11:36+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-joining-2-tables-and-save-into-third-with-duplicates-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] joining 2 tables and save into third with duplicates [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/20624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=20624"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/20624\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=20624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=20624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=20624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}