Getting error MSg208 when trying to create a view

  • chevo1

    Grasshopper

    Points: 12

    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
  • shmulikc1204

    SSC Enthusiast

    Points: 119

    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 2 (of 2 total)

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