Post reply

Getting error MSg208 when trying to create a view

  • July 1, 2020 at 12:08 am

    #3766592

    Any idea what I'm doing wrong? "Msg 208, Level 16, State 1, Procedure titles_borrowed, Line 4 [Batch Start Line 5]

    Invalid object name 'o'."

    CREATE VIEW titles_borrowed
    AS SELECT b.booktitle,o.bookid
    FROM books b 
    INNER JOIN o borrowed 
    ON b.bookid = o.bookid

  • July 1, 2020 at 5:54 am

    #3766609

    I assume you've  switched olaces between the table name (borrowed) and the alias (O).  The way you wrote it it looks like the table's name is o and the alias is borrowed, it is probably the opposite.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply