Re: Columns join help?

adn_at_kaija.spb.su (ADN communication group) writes:
>I have:
>Col1 Col2 Co3
>------ -------- -------
>This is line number 1
>This is line number 3
>
>Just I need:
>Col_Join
>-------------------------
>This is line number 1
>This is line number 2
>
>Is there simple query to do it?
>
>Thanks in advance.
>--
>Nick Maximov
>St. Petersburg, Russia

Yes, very simple.

   select col1||' '||col2||' '||col3 "Col_Join"    from table_name

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy_at_vistachrome.com, andy_at_genie.geis.com.
"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72