[thelist] SQL: insert into mutiple tables help

Scott Dexter sgd at ti3.com
Tue Apr 10 17:02:16 CDT 2001


> 
> > How can I insert a new email address into Subscribers and a 
> Subscriber
> > foreign key to Subscriptions at the same time? Since INSERT 
> INTO works
> with
> > only one table, is it possible?

If your db has triggers, a trigger that fires on inserts would be the slick
way to go. Rudy, what say you?


sgd




More information about the thelist mailing list