I have a database as
MemberId, Book No , bookissued on, book returned on and validdate.
There is no index .
I want to extract the data in such a way that in one row i should get the field - book no against each member id. one memberid can point to atleast 5 books.
please help. i feel it can be done with arrays , but how?