<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title>How to merge 2 tables into one result in MySQL</title>
		<description>Discuss How to merge 2 tables into one result in MySQL</description>
		<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html</link>
		<lastBuildDate>Sat, 11 Apr 2026 10:51:09 +0000</lastBuildDate>
		<generator>JComments</generator>
		<atom:link href="https://select-sql.com/jcomments/rss/com_content/9" rel="self" type="application/rss+xml" />
		<item>
			<title>Guest says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-449</link>
			<description><![CDATA[Hi, I need to get info from two tables with different columns, one table has two columns and the other table has four columns, this needs to be joined, linked for a result set what all info from the tables are displayed in one query using SQL on oracle 10G]]></description>
			<dc:creator>Guest</dc:creator>
			<pubDate>Wed, 09 Dec 2015 09:34:38 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-449</guid>
		</item>
		<item>
			<title>Jona says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-116</link>
			<description><![CDATA[Hi, Thanks to your post, it helped me a lot to came up with this table below. But I need to include additional column as a result of operation as shown here--- FOR EXAMPLE I GOT THE FOLLOWING RESULT BY USING UNION FROM 2 TABLES: REMARKS |RECEIVE|RELEAS E BEGINNING STOCK | 200 | 0 WAREHOUSE | 20 | 0 AGENCY | 0 | 150 DEPARTMENT | 0 | 45 TOGETHER WITH THIS RESULT AS OUTPUT,I NEED TO INCLUDE COLUMN 'BALANCE' AS (THE TOTAL FROM BEGINNING STOCK,will add RECEIVE value and will subtract RELEASE value) SO THAT RESULT WILL BE LIKE THIS, REMARKS |RECEIVE|RELEAS E|BALANCE BEGINNING STOCK | 200 | 0 | 200 WAREHOUSE | 20 | 0 | 220 AGENCY | 0 | 150 | 70 DEPARTMENT | 0 | 45 | 25]]></description>
			<dc:creator>Jona</dc:creator>
			<pubDate>Mon, 03 Sep 2012 02:10:05 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-116</guid>
		</item>
		<item>
			<title>HoverFusion says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-95</link>
			<description><![CDATA[WOW browsed for hours for solution, testing queries and going crazy not finding solution for my query... solved! Thanks, i am definately bookmarking this!]]></description>
			<dc:creator>HoverFusion</dc:creator>
			<pubDate>Wed, 04 Jul 2012 22:27:43 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-95</guid>
		</item>
		<item>
			<title>Spajar says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-72</link>
			<description><![CDATA[:lol: Thanks! Ur explanation so helpful for me.]]></description>
			<dc:creator>Spajar</dc:creator>
			<pubDate>Tue, 15 May 2012 03:19:39 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-72</guid>
		</item>
		<item>
			<title>g0hjq says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-38</link>
			<description><![CDATA[Thank you. That's exactly what I was looking for, and a very nice explanation of how it works.]]></description>
			<dc:creator>g0hjq</dc:creator>
			<pubDate>Tue, 25 Jan 2011 16:46:46 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-38</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-25</link>
			<description><![CDATA[Good to get feed back, that these pages are helpful. It motivates me to find more time to write something more :)]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Fri, 12 Mar 2010 08:22:10 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-25</guid>
		</item>
		<item>
			<title>Jacklyn Jade L. Lao says:</title>
			<link>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-24</link>
			<description><![CDATA[;-) It is quite difficult to learn but as I go further with this website, it's easy for me now to do it....]]></description>
			<dc:creator>Jacklyn Jade L. Lao</dc:creator>
			<pubDate>Fri, 12 Mar 2010 04:30:58 +0000</pubDate>
			<guid>https://select-sql.com/mysql/how-to-merge-2-tables-into-one-result-in-mysql.html#comment-24</guid>
		</item>
	</channel>
</rss>
