[thelist] SQL: insert into mutiple tables help

[Cory Preus]

Hey all-

A little SQL help for the little laddie if someone is so inclined.

I have two tables: Subscribers and Subscriptions. A Subscriber can have many
Subscriptions.

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? Or do I need to insert the email, run
another query to get the ID of the new Subscriber, and yet another SQL
statement to insert the SubscriberFK to Subscriptions?

I hope I'm clear (I'm getting a little flusterd writing this)...if not feel
free to ask me for clarification.

Cory