hi Friends ,
I have three tables :
1) Employee :
* Emp_No
*Emp_Name
* ………..
2) Job
*Job_No
* Job_Name
* ……………
Since the relation is (M:M) , that may an employee transfer from a job to other, the third table generated .
3) Org_Chart
* Emp_No
*Job_No
*Date
Now,
How can I get just the...