How to handle 2 queries, nestled in each other?
first of all, sorry for my bad english. :)
The problem I have at work is part of an Overdue Letter in Access.
The system we work with is Olib and is running on an Oracle database.
There are a few tables that we have to use.
First we have to look in the table 'Borrowers' if there are borrowers with an overdue book(s) and a fine to pay.
For all the users we find in this table we have to look in 'Copies' to find out what books they have lend from us.
The first querie is:
"Select borrower, fname From borrowers Where and b.curbal > 0 and b.curodues > 0"
When we have the result of this queries (for ex. 7 barcodes of people) we have to look for each of the barcodes wich books they have lend here.
Select copynro From copies Where "The barcode of the borrower from the 1st querie" = borbarcode"
I hope you see my problem, if not I will try to explain it further more.