динамически Как вставить данные из нескольких таблиц в одну таблицу

таблица 1:

Groupname   View
member      table a
non member  table b

таблица a:

id  key
1   A
2   B
3   C

ТАБЛИЦА B:

ID  KEY
1   M
2   L
3   H
4   G
5   F

Конечный вывод:

GROUPNAME   KEY
member      A
member      B
member      C
non member  M
non member  L
non member  H
non member  G
non member  F