Re: SQL Experts Only

In article <MPLANET.3207f769kennedy989685_at_news.enteract.com>, kennedy_at_enteract.com (Ken Kennedy) wrote:

Try

insert into table_b (identifier_id, fk_table_a_id)

        select identifier_id, identifier_id
        from table table_a
        where ......

first row references field names in table_b the select stmnt ref. col. names in table_a. table_a must have unique or primary key on identifier_id for fk to be inforced.

Good luck,
Craig Received on Wed Aug 07 1996 - 00:00:00 CEST