title: How to get the data from after matching ids in database?
body: <p>Hi i am workin on a webapplication where manager assigns work to the employees from grid..</p>
  
  <p>i have database tables like this</p>
  
  <pre><code>     ManagerTable
        Customerid
        name
        and some other columns
       EmployeeTable
       empid
        employeeName
       Worktable
        CustomerID
        EmpID
  </code></pre>
  
  <p>Database:</p>
  
  <pre><code>Table 1                                               Table 2
  CustomerID | CustomerName|CustomerAddress          EmpID |EmpName
  ---------                                          -------------------
   1 | One    |--|--                                 1 | EmployeeName
   2 | Two                                           2 | EmployeeName
   3 | Three
  
              Table 3
              Tb1 | Tb2
              ---------
  //            1 | 1
  //            1 | 2
  </code></pre>
  
  <p>when ever manager assigns check box to a partcualr employee with unique id like(CustomerID,EmployeeID) should be store on a button click in worktable and i have to retriev the data from work table using the IDS stored in the table and show them in grid </p>
  
  <p>when ever a employee logins with his id it should check and get the data assigen to him in a grid  all the employees have same web page</p>
  
  <p>can any one help me with querys and code will be most helpfull...</p>