Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MYSQL - Concatenate two tables

I have two tables as follows:

    TABLE A                    TABLE B
 StuID | actid              FacID | actid
  3       12                  98      17
  5       17                  54      21

I want to list the name of everyone, both students and faculty, who participate in activity 17. Is there anyway I can get a result as below:

 id  | actid
 98     17
 5      17

WITHOUT creating a new table (by just using nesting of expressions or derived relations) ?

A JOIN on the actid would give something like:

StuID  | FacID  | actid
 5        98        17

I guess I need a form of concatenation??

like image 825
databasedude Avatar asked Oct 20 '10 01:10

databasedude


1 Answers

select * from table_a where actid = 17
union all
select * from table_b where actid = 17

You may (or may not) need to do something about the ids not being unique, such as

select 'Student', table_a.* from table_a where actid = 17
union all
select 'Faculty', table_b.* from table_b where actid = 17
like image 140
Thilo Avatar answered Nov 01 '22 14:11

Thilo