Re: Columns join help?
From: <hatzinger_m_at_bmwf1f.bmwf.gv.at>
Date: 8 Feb 93 09:55:57 +0100
Message-ID: <1993Feb8.095557.64_at_bmwf1f.bmwf.gv.at>
Date: 8 Feb 93 09:55:57 +0100
Message-ID: <1993Feb8.095557.64_at_bmwf1f.bmwf.gv.at>
In article <1993Feb06.104253.17084_at_kaija.spb.su>, 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?
Select Col1||' '||Col2||' '||Col3 "Col_Join" from table
kind regards
Mike
^ Federal Ministry of Science and Research B | M <-------------------------------------------------------------------------+----> Computer Center W | F | Ing. Klaus-Michael Hatzinger mail: hatzinger_m_at_bmwf1f.bmwf.gv.at | Bankgasse 1/209 phone: 0043-222-53120/5188 | 1014 Vienna, Austria fax: 0043-222-53120/5155 V ================================================================================Received on Mon Feb 08 1993 - 09:55:57 CET