Is there a relatively simple way to insert multiple rows into a table in which the data being inserted comes from both a select statement and hard-coded data?
For example,
insert into tblB
(field1, field2, field3)
values
( 950, select fieldA, fieldB from tblA )
...where 950 is a hard-coded value and fieldA and fieldB come from tblA
insert into tblB
(field1, field2, field3)
select 950, fieldA, fieldB
from tblA
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With