CODEWITHSUNDEEP
sqlmysqlunion
NumberFour
NumberFour

Reputation: 3611

Joining two similar tables in MySQL

I have two tables with similar columns - let's say table A with column LABEL_A and table B with column LABEL_B. The data types of LABEL_A and LABEL_B are same.

How can I select LABELs from both tables in a single query? (So the the result of the query contains single column LABEL containing data from LABEL columns of both tables).

EDIT: Can I use such UNION queries in a CURSOR?

Thanks for answers.

Upvotes: 2

Views: 3058

Answers (2)

OMG Ponies
OMG Ponies

Reputation: 332531

Use:

SELECT a.label_a
  FROM TABLE_A a
UNION ALL
SELECT b.label_b
  FROM TABLE_B b

UNION ALL will be faster, but won't remove duplicates if they exist. Use UNION if you want duplicates removed.

Upvotes: 5

Powerlord
Powerlord

Reputation: 88786

Use a UNION:

select LABEL_A as Label from A
union
select LABEL_B as Label from B

Upvotes: 3

Related Questions