Help

  • Thread starter Thread starter Marko
  • Start date Start date
M

Marko

I've jut finished doing a query to show information about
students who loan books. However, each row of information
has been replicated four times. What have I done?

The query shows Student Name, Book Number, Loan Date,
Loan Due, Loan Returned, Days Late and Fine Amount.

my table relationships are

STUDENT LOAN INSTANCE BOOK


Student Name Student Name Book Number ISBN
Age Book Number ISBN Author
Class Loan Date Instance Number Genre
Loan Due Department
Loan Returned Age Group
Fine Publisher


Can anyone help.
 
Isn't this the same question you have asked elsewhere? Have you learned
anything from the gentle prodding of other responders to continue in the
same thread with the same basic issue? Did you not understand the many
responses from those trying to help that suggest you post the SQL view of
your query? Do you think you could provide a more descriptive Subject?
"Help" is the basic reason for every original post in these news groups.
 
Back
Top