전체 검색을 할 때 테이블명도 같이 리스트로 뽑을 수 있을까요?

select * from 

(select id,title,name,content,date,cnt from table_a 

where (name like '%$search%') or (title like '%$search%') or (content  like '%$search%')  

order by id desc limit $limit offset $positionx) a 

UNION ALL 

select * from 

(select id,title,name,content,date,cnt from table_b

where (name like '%$search%') or (title like '%$search%') or (content  like '%$search%')

order by id desc limit $limit offset $positionx) a

table_a id title name content date cnt

table_b id title name content date cnt

table_a id title name content date cnt

table_a id title name content date cnt

table_b id title name content date cnt

이런식으로....