Adding values from two table and storing into third table

Question

INSERT INTO Table1 (Amount, ContactName, State, City) 
values 
(
    (Select Amount from Table2 where id=12)+
    (Select Amount from Table3 where id=13),
    'Sam',Newyork,'Newyork'
);

I was trying to Store the value of amount in Table1 by the sum of Table2 + Table3 Amount

And what is the Problem with it?

Jens
– Jens

2016-06-07 05:41:23 +00:00
Commented Jun 7, 2016 at 5:41 — Jens
– Jens, Commented Jun 7, 2016 at 5:41
Any database exception?

wumpz
– wumpz

2016-06-07 05:43:24 +00:00
Commented Jun 7, 2016 at 5:43 — wumpz
– wumpz, Commented Jun 7, 2016 at 5:43
You have missed out on '' around the State variable.

Marcus Höglund
– Marcus Höglund

2016-06-07 05:46:10 +00:00
Commented Jun 7, 2016 at 5:46 — Marcus Höglund
– Marcus Höglund, Commented Jun 7, 2016 at 5:46
So what you are getting ? any result or an error ?

Vishal Suthar
– Vishal Suthar

2016-06-07 05:52:51 +00:00
Commented Jun 7, 2016 at 5:52 — Vishal Suthar
– Vishal Suthar, Commented Jun 7, 2016 at 5:52

pariasdev · Accepted Answer · 2016-06-07 05:55:46Z

1

You could also try another way:

INSERT INTO Table1 (Amount, ContactName, State, City) 
values 
(
     select sum(Amount) Amount
       from (Select Amount from Table2 where id=12
             union all
             Select Amount from Table3 where id=13),
    'Sam',Newyork,'Newyork'
);

answered Jun 7, 2016 at 5:55

pariasdev

5815 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dcieslak · Accepted Answer · 2016-07-04 05:10:55Z

1

Try with nvl(sum(Amount),0). The SUM will sum all values in the table and if there will be no rows you will get NULL. The NVL will remove possible NULL and it will replace it with 0.

INSERT INTO Table1 (Amount, ContactName, State, City) 
values 
(
    (Select nvl(sum(Amount),0) from Table2 where id=12)+
    (Select nvl(sum(Amount),0) from Table3 where id=13),
    'Sam','Newyork','Newyork'
);

edited Jul 4, 2016 at 5:10

answered Jun 7, 2016 at 5:45

dcieslak

2,7151 gold badge15 silver badges20 bronze badges

Collectives™ on Stack Overflow

Adding values from two table and storing into third table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related