Re: What's wrong with this question?
From: Russ Whiteman <russw_at_inlink.com>
Date: Sun, 27 Dec 1998 23:18:10 -0600
Message-ID: <7674ut$op2$1_at_news1.inlink.com>
Date: Sun, 27 Dec 1998 23:18:10 -0600
Message-ID: <7674ut$op2$1_at_news1.inlink.com>
In this case, we don't really need more info... you can't ORDER a view. The ORDER clause belongs in the SELECT query that uses the view.
James A. Johnson wrote in message <3686DE35.C12E8C26_at_bellsouth.net>...
> WHich clause caused an error? why?
>
>A little more info please.
>
>WLD1838 wrote:
>
>> Hi,
>>
>> This is the question:
>> You attempt to create a view with this command:
>> CREATE FORCE VIEW lat_first vu
>> AS SELECT first_name ||' ' || last_name " Emplyee Names"
>> FROM employee
>> ORDER BY lat_name, first_name;
>> WHich clause caused an error? why?
>>
>> Anyone knows the anwser, please help.
>>
>> Thanks in advance!
>>
>> Helen
>
Received on Mon Dec 28 1998 - 06:18:10 CET