var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to get summed data from 2 diff. Tables not related Logically
My prob. may seem simple for u but it's a problem for me.....
there is two different table with only column..
create table amoun1(amt number(5))
create table amoun2(amt number(5))
now i hev inserted 4 rows in first table (amount1) 20,20,20,20 and
i hev inserted 4 rows in second table (amount2) 30,30,30,30
i want result in this format....
expected result is.........
but.....i tried all possibilities.....but not finding the optimum solutions.....
so pls reply with the optimum solution.......
( select sum(amt) from amount1 ) amount1_sum
, ( select sum(amt) from amount2 ) amount2_sum
for ur kind help...........