I want to retrive data from two tables. I used below code :
(SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from settlement where sett_status = 'Active')
But It load data by one column and these two values load under the another values
I want to recieve those values to two columns...
Becuase I want to retrive these to vb.net variable for make chart.