HI friends,, please help me to clear me doubt..

Scenario



As It is presented in the above picture... all logic related to customer is processed throught cutomerBAL class and logics related to Orders are processed through OrdersBLL. Same like.. all process with Customer table is procecesd by CustomerDAL and Order table with OrdersDAL.

so. each table has its own entity. Meantime..If I want o execute a joint query between Customers & Orders, which class will process it? Do I need a seperate entity for that?

Please help me to clear my doubt..