Re: QUERY WRITING

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.