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