Doubt, how to use a sum command, with a result of 3 tables

[marques1908]

Good morning, only beginner in SQL / Plus on Oracle Base, and I need to make a survey where I return the result of several customers, where the information is, the total annual movement (Table1), the total value (Table2) and qtde days of movement (Table3).
You can help.
grateful

[Trevisolli]

Brother,

One of the ways of getting whatever, would be with Union:

Select all

 
select sum(qtd) qtd 
from tabela1 
union  
select sum(qtd) qtd 
from tabela2 
union 
select sum(qtd) qtd 
from tabela3; 

see if it helps you and, anything, send us.