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??
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With