mysql之多表联合查询并输入数据来自哪张表

比如联合查询3个表，表名分别叫a,b,c

select'a'tbname,a.*fromaunionallselect'b'tbname,b.*frombunionallselect'c'tbname,c.*fromc