Insert into 2 tables at once

[rpupkin77]

Hello,

I am realizing now that I have never done this before. I need to insert information - all at once into two seperate tables joined by a fk.

So essentially I need to insert into one table then get the primary id from it and then insert this value long with the other fields - into the 2nd table.

Can I do this without writing 2 insert statements - perhaps using a join?

If so what is the basic syntax?

Thanks.

[ahundiak]

You need two insert statements. No way around it short of writing a stored procedure.