Library Database

[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.

 

[Douglas J. Steele]

What's the SQL of your query?