Syntax<\/h2>\n

<\/div>

SELECT column-namesFROM table-name1 JOIN table-name2 ON column-name1 = column-name2WHERE condition<\/code><\/pre> <\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Answer : The union operator combines the results of two or more queries into a single result set…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[6547],"tags":[195,6595,203,199,214,198,209,283,205,6742,6787,6743,6744,6745,6746,2936,222,6775,484,196,212,6776,6772,6773,286,6778,6777,970,207,6771,6747,6784,6748,6749,6750,204,6751,6774,6752,282,208,288,206,6753,6754,6767,6755,6630,6756,6770,6769,6757,6758,6768,6779,6781,6759,6760,6761,6762,6763,975,200,6780,6786,6764,6765,6766,6783,197,284,280,364,6785,6782,285,15907],"class_list":["post-968","post","type-post","status-publish","format-standard","hentry","category-sql","tag-accenture-interview-questions-and-answers","tag-allstate-solut-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-chetu-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-conduent-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-difference-between-cartesian-product-and-union","tag-difference-between-join-and-union","tag-difference-between-join-and-union-with-example","tag-difference-between-or-and-union-in-sql","tag-difference-between-union-all-and-union","tag-difference-between-union-and-full-outer-joinfull-outer-join-vs-union-all-performance","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-full-outer-join","tag-genpact-interview-questions-and-answers","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-inner-join","tag-join","tag-joins","tag-lt-infotech-interview-questions-and-answers","tag-left-join","tag-left-outer-join","tag-mindtree-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-mysql-inner-join","tag-mysql-join","tag-mysql-union","tag-mysql-union-example","tag-mysql-union-join-difference","tag-natural-join-in-sql","tag-oracle-corporation-interview-questions-and-answers","tag-oracle-sql-union","tag-outer-join","tag-outer-join-in-sql","tag-persistent-systems-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-r-systems-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-self-join-in-sql","tag-sql-full-join","tag-sql-inner-join","tag-sql-inner-join-where","tag-sql-join","tag-sql-join-3-tables","tag-sql-join-types","tag-sql-left-join","tag-sql-left-outer-join","tag-sql-multiple-joins","tag-sql-outer-join","tag-sql-union","tag-sql-union-all","tag-sql-union-all-example","tag-sql-union-distinct","tag-sql-union-order-by","tag-sql-union-vs-join","tag-sql-union-vs-union-all","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-trade-union","tag-union-all","tag-union-and-join-together-in-sql","tag-union-in-sql-server","tag-union-vs-join-performance","tag-unions","tag-unitedhealth-group-interview-questions-and-answers","tag-valuelabs-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-a-union","tag-workers-union","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers","tag-xt-global-interview-questions-and-answers"],"yoast_head":"\n