Insert Selecte

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

Combine insert select statements 0
Combine insert select statements with known value 1
Concatenation of detail-records in a Master-Detail relationship 2
Insert multiple objects at once ? 3
Autonumber field in Excel that behaves the same as Access 0
Newbie Help - IF Yes No Function 0
How much it TOO much? 0
Advanced Drop Down List Option 0

Top