Defining foreign keys!
What I am trying to do is take information from two tables and put them into a new table.

For Example:

members table:
id int not null auto_increment primary key
fname.........
lname........
email varchar (150)

books table:
id int not null auto_increment primary key
title............

New table:
mebers_id
email
books_id

How would I define these if they are defined as above in there original tables.

Also can I take information from tables in one database and add to another database?

Atia