select - SQL question

[csvideo]

How can I select records from a local view the way I can select them from a table?

Example of select from a customer table :-

SELECT * FROM customer

I need to select from local View.

 

[ajoyk]

Hi

You will have to do the same thing. There is no difference.
if customerview is a view of customer then you can
Select * from customerview.

Hope this helps

AjoyK

 

[DEDMOD]

And the same is true of remote views as well. Except, of course, that you need some sort of connection to set up a remote view. The whole point of views is to create something that you can use just like a table.

Dave Dardinger