A question about views

jonhmardona

I created a VIEW name newAuthors and I can access it like so:

SELECT *
FROM books.dbo.newAuthors au
where Row>=5 AND Row<=15
order by au.au_lname desc;


My question is I can access a normal table without using books.dbo.authors as in

select * from authors;

but if I try doing the same thing with a view I get errors unless I use the books.dbo.newAuthors. Why can't I just access the View like a normal table?






los angeles business investors

garak

and you are sure that you have connect before to the database books :?:
You are a member of the shema dbo :?: