do have a database a book firm.
There are such tables:
Books, Partners,Orders,Orders details,
I do need to make a report showing by partners which books and when they have ordered.It should look like:
Partner 1
........... .... 23.12.01 25.12.01 22.04.02
1.Book A......2
2.Book B ........................ 2.............. 2
3.Book C......2
The same for each parner (the dates should be the dates of the orders made by this partner and they are uniqe for each of them)
Could you please help me how it could be done.
Thank you
Arseniy
There are such tables:
Books, Partners,Orders,Orders details,
I do need to make a report showing by partners which books and when they have ordered.It should look like:
Partner 1
........... .... 23.12.01 25.12.01 22.04.02
1.Book A......2
2.Book B ........................ 2.............. 2
3.Book C......2
The same for each parner (the dates should be the dates of the orders made by this partner and they are uniqe for each of them)
Could you please help me how it could be done.
Thank you
Arseniy