union-all

[Solved] Read data from two tables

by

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 1 solved Read data from two tables