RE: x-ref insert from within an insert. . .select

2002-03-20 Thread Andrew Hazen
Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:12 PM To: Andrew Hazen; [EMAIL PROTECTED] Subject: Re: x-ref insert from within an insert. . .select At 11:42 -0500 3/20/02, Andrew Hazen wrote: >Hi, >I am loading table A from values in table B with an insert .

Re: x-ref insert from within an insert. . .select

2002-03-20 Thread Paul DuBois
At 11:42 -0500 3/20/02, Andrew Hazen wrote: >Hi, >I am loading table A from values in table B with an insert . . . select >statement. >I also need to populate a x-ref table with the new insert ids from the >insert . . . select. > >I know in Oracle I would put a trigger in to do the x-ref insert af