hi all
I need some logic to implemnt the following
my database has some data like
person_id | emp_id| job | grade | date_of_creatio n--for grade
------------------------------------------------------------------------------------------------
62 | 1009 | Asscociate partner | L1 | 20/12/2003
62 | 1009 | Assocaiate partner | L2 | 11/10/2004
62 | 1009 | Associate Partnet | L3 | 12/03/2007
Now my report(promotio ns report ) has to display person _id, emp_id job and all the grades the employee has come across. So, it should display the details of promotion i,e from L1 to L2 to L3.
Person Id and emp_id are from same table and the rest three columns are from three different tables.
Please suggest me a logic or query to get the details as required.
thank you
I need some logic to implemnt the following
my database has some data like
person_id | emp_id| job | grade | date_of_creatio n--for grade
------------------------------------------------------------------------------------------------
62 | 1009 | Asscociate partner | L1 | 20/12/2003
62 | 1009 | Assocaiate partner | L2 | 11/10/2004
62 | 1009 | Associate Partnet | L3 | 12/03/2007
Now my report(promotio ns report ) has to display person _id, emp_id job and all the grades the employee has come across. So, it should display the details of promotion i,e from L1 to L2 to L3.
Person Id and emp_id are from same table and the rest three columns are from three different tables.
Please suggest me a logic or query to get the details as required.
thank you