Combine insert select statements

P

Peter

Hi!

Is it possible to combine insert statement with one known value and one
returned by select statement, eg.

insert into Table (u_id, dep_id)
values (2354, select dep_id from Department where dep_id = (
select max(dep_id) from Department)

Thanks!

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Selecte 0
Combine insert select statements with known value 1
Concatenation of detail-records in a Master-Detail relationship 2
Page numbering with Merged Document and IF statements 1
Insert multiple objects at once ? 3
Combining three files when middle file has sections with endnotes 2
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Autonumber field in Excel that behaves the same as Access 0

Top