S
Stephen Raftery
Hi all, I wonder can anyone help.
I have a database with a Transactions table, and an Items table. Each Item
is linked to a certain Transaction vie the TransactionID.
I also have two other tables called ScheduledTransactions and
ScheduledItems, where each ScheduledItem is linked to a certain
ScheduledTransaction. Each month I append the appropriate Scheduled things
into the main table.
I would like to be able to write some kind of nested Insert statement in SQL
that would do this, while mirroring the links between Items and Transactions.
Does anyone know how this should happen?
Stephen
I have a database with a Transactions table, and an Items table. Each Item
is linked to a certain Transaction vie the TransactionID.
I also have two other tables called ScheduledTransactions and
ScheduledItems, where each ScheduledItem is linked to a certain
ScheduledTransaction. Each month I append the appropriate Scheduled things
into the main table.
I would like to be able to write some kind of nested Insert statement in SQL
that would do this, while mirroring the links between Items and Transactions.
Does anyone know how this should happen?
Stephen