Joining two unrelated tables in MYSQL

Question

0.00/5 (No votes)

See more:

Hello,

I have two tables:

Table 1

sku	product_name	color
1a	product1	black
1b	product2	red

Table 2

sku	product_name	dimensions
2a	product3	10x10x30
2b	product4	20x25x50

These tables belong to different product category types. sku is a primary key for each table. I need a master table that contains all products from every category type. The master table that I need is like:

Master Table

sku	product_name	color	dimensions
1a	product1	black
1b	product2	red
2a	product3		10x10x30
2b	product4		20x25x50

How can I join Table1 and Table2 to get Master Table?

Thank you.

Posted 6-Dec-11 13:05pm

Soner Aydemir

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Damian S_ · Accepted Answer · 2011-12-06T14:17:00

Solution 1

Use a union query.

eg:

SQL

select sku, product_name, color, '' as dimensions from [table 1]
union all
select sku, product_name, '' as color, dimensions from [table 2]

Posted 6-Dec-11 14:17pm

_Damian S_

Comments

Soner Aydemir 6-Dec-11 20:26pm

Thanks for the answer. I've about 10 tables, each table has about 100 columns and each table has some common columns. Is there any solution to merge them automatically or do I need to enter all the columns one by one like your example?

_Damian S_ 6-Dec-11 20:36pm

Sadly, you will need to do it like my example if you are wanting it to turn out like your question above... It's important to use the same number of fields in the same order for each table!!

Soner Aydemir 6-Dec-11 21:30pm

Thank you very much.