how to add values to a table which is calculated from other table

Question

0.00/5 (No votes)

See more:

I need to insert value into table called sales (scriptname,accnum,remainingshares) from table transac (scriptname,accnum,sharesbought,sharesold).
I want to calculate remainingshares = sharesbough - sharesold.

Can I do this by the following query??

SQL

INSERT INTO sales(accnum, scriptname, remainingshares) 
select accnum,scriptname,sharesbought-sharesold
from transac

Posted 11-Sep-15 1:01am

Member 11949886

Updated 11-Sep-15 10:08am

Maciej Los

v2

Add a Solution

Comments

Schatak 11-Sep-15 7:22am

Yes you can do it by this query
INSERT INTO sales(accnum, scriptname, remainingshares) select accnum,scriptname,(sharesbought-sharesold) remainingshares from transac

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

FrankNight · Accepted Answer · 2015-09-11T01:16:00

Solution 1

Try to set a column alias:
(sharesbough - sharesold) as remainingshares.

Posted 11-Sep-15 1:16am

FrankNight

Comments

Maciej Los 11-Sep-15 16:10pm

Sounds reasonable. +5!

how to add values to a table which is calculated from other table

1 solution

Solution 1

Add your solution here

Preview 0

how to add values to a table which is calculated from other table

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us