Subject Views and where clauses
Author Johannes Pretorius
Good day

I want to know if how I understand VIEWS are correct.

The view is a query stored on the server that gets run when the user executes it.
if a where clause is added to the VIEW from a query as in :

select * from myVIEW where ref_no >= 4599

the Server will FIRST execute the View then implement the where clause on the views result.

Otherwise only views that is on ONE table can be updated.

Thanks in Advance for any responses.

Yours Sincerely

Johannes Pretorius


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.718 / Virus Database: 474 - Release Date: 09/07/2004

[Non-text portions of this message have been removed]