I am doing a select SQL from a View that is optomistic table buffered agianst one table. The values in the view are different from those in the table because I have not sent any updates to the table yet. When I do the select naming the view in the FROM clause (the table isn't open and dosn't have the same name) the result set contains the values in the table, ie the oldvalues in the view.

So my question is, how can I select the values actualy in the view short of scanning it.