Innerjoin between Two Data Layer Classes

Hi
   All I create two Data Access layer Classes on Two SQLServer Table
Employee                   Leave
-----------             -------------------------
Name                  LeaveFrom
Address               LeaveTo
CompanyID          CompID
BranchID              Branch

Above two Fields need to create on each table CompanyID and Branch ID tha creates extra load on Size of DB. I created a class that generates automatic select Query on on a particular Table.

Now I want to create ...