hi i have 2 tables sales_invoice and credit_memo. is it possible to
join this 2 tables so it looks like

Type Customer Doc No. Amount
----------------------------------------------
Invoice A 1 $10000
Credit Memo B 1 $15000


thanks for any comments