combined Insert/Select statement

[Jeroen Vandezande]

Hi all,

This is probably a stupid question but I am new to SQL so...

I want to insert data into a table coming from another table but also from Parameters that are filled by my program.
So I know I can do something like this:

INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

But combined with that I want also insert some data with paramaters...
Can that be done in one statement?
Do I have to do it in an update statement later on?

Best Regards,

Jeroen Vandezande