Re: Why can't I with a view (calculated column)
> Why can't I create a view with a calc column
> ie.
>
> create view tst> as
> select ship_charge - totval cout
> from orders
> where ship_charge > 0;
>
> This is a simplification of the real thing, It complains as follows
> "view column for aggregate or expression must be explicitly named"
Try
create view tst (cout) asselect ship_charge - totval from orders where ship_charge > 0;
Naming is done at the view level not at the select level.
Cheers - Jim
--------------------------------------------------------------------
Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM
Company: DHL Systems Inc Phone: (415) 358-5911 (Work)
Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home)
San Mateo, CA 94402 Fax: (415) 571-6429
--------------------------------------------------------------------