[Solved] Read data from two tables

You may need to put both columns in the union all:

select cr_amount,Null as 'db_amount',created from table_credit
union all
select Null,db_amount,created from table_debit
order by created