Hello everybody , this is my first participation here , I am hoping find the help .

I am trying to develop a small application witch manage a small shop location.
I created the appropriate tables (Client, provider , product , bill ,command ) .
Among the scenarios witch is present in my future application : searching for all products witch is sold for specific client in a specific period .
To do that must I create a new table named "Archive" to add in it all information needed for this scenario ? Or I can with using SQL instructions to retrieve these information from bill table and Product table for example ?