SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Jan 2004
    Location
    GA
    Posts
    104
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Gurus ! help with Views

    Hi Guru,

    I am trying to create a view for 2 oracle table.

    Employee
    =======
    EmpID
    Empname

    EmployeeDetails
    =============
    EmpDetailID
    EmpID
    DeptID
    FromDate
    ToDate

    I have to show on screen, like below :-

    Electr. Computer Mechanical
    EmpID EmpName From - To From-To From-To
    ================================================

    Could somebody tell me, how we can create view for the above to display ?

    Thanks !

  2. #2
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    Moscow, Russia
    Posts
    557
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, would you post structure or DDL for your tables to be queried


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •