Getting data from Multiple tables

Question

 

Hi,

       I have Multiple tables in my database nearly 200. I want to get the data from all the tables based on an Order Number. Is it possible?. I need to get all the data related to that order number in all the tables and display in another table.

 

thanks