Insert Into Two Tables

[patelaashish]

Hi,

I have having problems inserting data into two tables.

I have two tables j and b.

there is jid,bBoxtotal, column in j table
there is bjobid,bBoxNumber,bBoxtotal in b table

What I need to do is insert first into j table and get the last jid and insert that into b table column bjobid.

Can anyone please help?

Thanks.

[jayadevi]

Hi ,

You didn't mention which database server you are using. Assuming that you are using SQLServer and jid column in j table is set to default identity.

INSERT INTO j ( bBoxtotal ) VALUES ( 35 ) //inserting into j table

DECLARE @last_id int

SELECT @last_id = max(jid) FROM j //getting the last jid

INSERT INTO b ( bjobid , bBoxNumber , bBoxtotal )
VALUES ( @last_id, 2 , 35) // inserting into b table

Thanks,
Jaya.S

[vssp]

If mysql server how to insert two table ?

vssp