How to insert into table from another table using conditional select

Question

I have UCP table and SalesPerProduct which contained data I want to insert into SalesPerProduct From UCP Conditional select When i do select it works fine i used this query

select t.ID, sum(Qty) as sum_BioxellTerritories , 
sum(SalesResult) as Sales , BioxellTerritories 
from UCP as t group by ID ,BioxellTerritories
ORDER BY BioxellTerritories ASC

when I Used insert

insert into SalesPerProduct 
(ProductID , Volume , Sales ,Territories )values
select t.ID, sum(Qty) as sum_BioxellTerritories , sum(SalesResult) 
as Sales , BioxellTerritories from UCP as t group by ID ,BioxellTerritories   ORDER BY BioxellTerritories ASC

Didn't work for me .. for sample of data This is the result of select which I want to insert

what didn't work for you? did you get an error? you need to remove order by during insert and remove values (as you are using a select) — Vamsi Prabhala
– Vamsi Prabhala, Commented May 1, 2017 at 23:59
ty :) works for me can u write ur answer to accept it u deserve it :) — Amr Kamal
– Amr Kamal, Commented May 2, 2017 at 0:03
The same answer has already been posted, feel free to select one of them :) — LordBaconPants
– LordBaconPants, Commented May 2, 2017 at 0:06

Gordon Linoff · Accepted Answer · 2017-05-02 00:05:49Z

2

You just want insert . . . select:

insert into SalesPerProduct (ProductID, Volume, Sales, Territories )
    select t.ID, sum(Qty) as sum_BioxellTerritories, sum(SalesResult) 
as Sales, BioxellTerritories
    from UCP as t
    group by ID, BioxellTerritories
    order by BioxellTerritories ASC ;

The VALUES keyword is unnecessary.

answered May 2, 2017 at 0:05

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

1 Comment

Nick.Mc Over a year ago

Also note as per this answer: always use a target column list with the insert statement

Extragorey · Accepted Answer · 2017-05-02 00:03:27Z

1

Have a look at this reference for INSERT INTO SELECT statements: https://www.w3schools.com/sql/sql_insert_into_select.asp

In short, you don't need the VALUES keyword when combining a SELECT statement with INSERT INTO.

If you still have problems I'd suggest posting your table definitions so people can help you further.

answered May 2, 2017 at 0:03

Extragorey

1,76421 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to insert into table from another table using conditional select

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related