Ricavare la tabella da cui proviene il record..

[stabi]

select campi,'tabella1' as origine from tabella where ....
union
select campi,'tabella2' as origine frm tabella3 where .....
union ...