Create View Query

[Sol]

Can anyone help me to figure out how to do a Create View Query?

Thank you,
Salomon

 

[S.Clark]

Semantics:
View in SQL Server = Query in Access

Thus, there isn't such a thing as a 'View Query'

Please be more specific about your needs.

 

[John Spencer]

In Access and JET (native database engine) you just build a query, you don't
create views.

If you are using some other database engine, the create view code will be
specific to that engine.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Sol]

I apologize for the confusion.

I actually need to “define, describe and use views in SQLâ€. The problem is
that I don’t know how to do it. I have tried a few times and came up empty.

Here is the example:

Create a view named PenguinBooks. It consists of the book code, book
title, book type, and book price for every book published by Penguin USA.
Display the data in the view.

Thank you,
Salomon