|
-
May 29th, 2007, 01:23 AM
#1
Thread Starter
Lively Member
[2005] how to insert into 2 tables at once?
Hi,
I have two relational tables in my project, and I have to insert data into both of them at one,, or since the first table was filled,, the second should be too ..
for example I have a book table, and book info table ..
in the book I would have the ISBN, name .. etc ..
book info has FK (ISBN) and other info about the book such as:description, category .....
information about the book are in a text file, I want to extract the information
and have them into two tables with a FK (ISBN) between them ..
can I insert into these two tables at once??
if yes, how ?
if no , what should I do instead ?
thanx in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|