Re: QUERY WRITING

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2004.11.26.08.20.33.91600_at_sbcglobal.net...
> On Thu, 25 Nov 2004 11:25:58 -0800, Segun wrote:
>
> >
> > Can someone please help generate a code to produce an output as shown
below
>
> of course: TRUNCATE TABLE will give you the expected results.
> If your table is called MYTABLE you should execute the following:
> TRUNCATE TABLE MYTABLE;
> AS SELECT PRODUCT, ENGLANd+GERMANY+FRANCE+USA
> /
>
> Don't forget the semicolon at the end of the 1st line or the
> statement will not work. You don't have to thank me.
>
> --
> Artificial Intelligence is no match for natural stupidity.
>

That is one of the most elegant solutions I've ever seen! One minor thingthe  "d" in ENGLANd should be uppercase, just for consistency. Thanks! Perhaps others asking this question will adopt this solution as well. Good job! Received on Fri Nov 26 2004 - 17:26:39 CST