>Hi All
>
>After creating a view. I need to change
>" on " statement from " on view1.field1 = view2.field1"
>to " on view1.field1 $ view2.field1"
>
>But I could not edit it in the view sql satement
>windo (read-only). Is it possible to edit
>this statement some other place after I created this loca view?
>
>Thank you for in advance.
>
>Aiko Ichimura
You cannot edit in View-SQL window. But, you can use CREATE SQL VIEW command to do it from command window:
SELECT SQL VIEW myview AS Select myfield From mytable Where ....
Edward Pikman
Independent Consultant