union-all

[Solved] Read data from two tables

by

[ad_1] 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 [ad_2] solved Read data from two tables