How to do Query in Sql Server

Question

Hi...
I have a problem .... I'm trying to execute This Querry but give me an error

insert into GenStoTable(ProductID,StID,Quantity,LowQ)(select (select id from ProductTable),max(ID),0,0 from StrNamTable)

I'm trying to use insert into with select from 2 tables .... please help me ... and thank's alot

Answer 1

Try removing "( )":

insert into GenStoTable(ProductID, StID, Quantity, LowQ)
select (select id from ProductTable), max(ID), 0, 0 
from StrNamTable

It assumes that ProductTable has a single row, otherwise it cannot work.

Give details if you need something different.

Answer 2

Hi @Nona Mohammed ,

the final result that need it
GenStoTable ProductID StID Quantity LowQ
4 3 0 0
5 3 0 0
6 3 0 0
7 3 0 0

Please refer below:

 insert into GenStoTable(ProductID,StID,Quantity,LowQ)  
 select id ,(select max(id) from StrNamTable),0,0 from ProductTable  

Output:

ProductID	StID	Quantity	LowQ  
4	3	0	0  
5	3	0	0  
6	3	0	0  
7	3	0	0  

Best regards,
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.