> yes i'd like to union this tables. but is it possible to know if the
> record comes from which table?
>
>

Of course, that's trivial actually.

select 'Invoice' type, ... from sales_invoices
union all
select 'Credit Memo', ... from credit_memo

Sasha