Thread: Creating Views

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2015
    Posts
    1
    Rep Power
    0

    Angry Creating Views


    I have this select that works. I tried to create a View using it and got a 'unsuccessful metadata update' error. When I tried to create it again, it says that the table/view already exists.

    But, the view is not in the View list and I can't query from it, getting the error that the view does not exist.

    Can anyone help me get this view created?

    Thanks for any help.

    Code:
    CREATE VIEW V_DJ_QI
    (
     JOBNUM,
     MILE,
     BASEEND,
     SCHEND,
     ACTEND,
     MILEID
    ) AS
    select  j.job_number as jobnum, m.milestone_name as mile , sm.base_end_date as baseend,
    sm.SCH_END_DATE as schend, sm.ACTUAL_END_DATE as actend,
    m.milestone_ID as mileid
    
    from job j
     inner join schedule s 
    on (s.Job_number = j.job_number)
     inner join schedule_milestone sm 
    on (sm.schedule_id = s.schedule_id)
     inner join milestone m 
    on (m.milestone_id = sm.milestone_id)
    where m.milestone_ID = '11';
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2008
    Posts
    74
    Rep Power
    10
    try with IBExpert software excelent software

IMN logo majestic logo threadwatch logo seochat tools logo