-
Experts in View
I am trying to create a View with 2 oracle table.
Employee
=======
EmpID
Empname
EmployeeDetails
=============
EmpDetailID
EmpID
DeptID
FromDate
ToDate
I have to show on screen, like below :-
EmpID EmpName Dept1(From - To) Dept2(From - To) Dept3(From - To)
===================================================================
In "EmployeeDetails" table, empid can be multiple with unique deptid .
say,
empid =1
deptid =1
fromdate=1/1/2005
todate=2/1/2005
empid =1
deptid =2
fromdate=3/23/2005
todate=3/29/2005
empid =1
deptid =4
fromdate=1/2/2005
todate=3/18/2005
empid =8
deptid =2
fromdate=1/5/2005
todate=5/11/2005
So, how can we create view , so that shows the output I shown above ?
Thanks !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|