join - MySQL - Display data from TWO tables in ONE Column in TWO rows -

my problem following:

i have 2 tables same datatypes. 1 called "rechnung" , 1 "rechnungarchiv".

example row:

rg_id | rg_kdid | rg_datum | rg_summe | rg_anzpos db5   |4711     |2010-etc. |2500.00   | 5 

one table holds up-to-date data, other 1 archive old data. have display e. g. rg_id , rgar_id (two id same format) in 1 column, in 2 rows. query far:

select  concat(r.rg_id, a.rgar_rgid) rechnungsid,  concat(r.rg_kdid, a.rgar_kdid) kundenid,  concat(r.rg_datum, a.rgar_datum) rechnungsdatum,  concat(r.rg_summe, a.rgar_summe) rechnungssumme rechnung r inner join rechnungarchiv on r.rg_kdid = a.rgar_kdid 

what this:

db5db1  47114711    2010-06-03 00:00:002009-10-11 00:00:00  2500.00003725.0000 

i want data 1 table @ time displayed. how do this?

thanks in advance.

you're looking union operation:

select 'rechnung' type, rechnung.*   rechnung  union select 'archiv' type, rechnungarchiv.*   rechnungarchiv; 

see fiddle: http://sqlfiddle.com/#!9/04e31e/12