Position of Table Columns
Position of Table Columns
am 02.01.2008 10:31:21 von Ganapathi sundaram
Dear All,
I want to get more than one table columns as a single column by
alternative.
For eg,
Table name = employee
columns = empid, empname, address1,address2
Here, I want to interpolate the address2 column on address1 as
mentioned below,
empid empname address1
address2
1 aaa First Layout,
CA, US.
Thanks in advance.
Thanks and Regards,
Ganapathi sundaram.G
Re: Position of Table Columns
am 02.01.2008 15:32:07 von Tom van Stiphout
On Wed, 2 Jan 2008 01:31:21 -0800 (PST), Ganapathi sundaram
wrote:
How about this:
select empid, empname, address1 + CHAR(13) + CHAR(10) + address2
from employee
-Tom.
>Dear All,
>
>I want to get more than one table columns as a single column by
>alternative.
>
>For eg,
>
>Table name = employee
>
>columns = empid, empname, address1,address2
>
>Here, I want to interpolate the address2 column on address1 as
>mentioned below,
>
>empid empname address1
> address2
>
>1 aaa First Layout,
> CA, US.
>
>
>Thanks in advance.
>
>Thanks and Regards,
>Ganapathi sundaram.G
Re: Position of Table Columns
am 02.01.2008 22:15:16 von Joe Celko
>> I want to get more than one table columns as a single column by alternative. <<
Formatting is done in the front end in a tiered architecture, never in
the database. This is a basic programming concept and applies to more
than just SQL.
Re: Position of Table Columns
am 03.01.2008 14:36:53 von Madhivanan
On Jan 2, 2:31=A0pm, Ganapathi sundaram
wrote:
> Dear All,
>
> I want to get more than one table columns as a single column by
> alternative.
>
> For eg,
>
> Table name =3D employee
>
> columns =3D empid, empname, address1,address2
>
> Here, I want to interpolate the address2 column on address1 as
> mentioned below,
>
> empid empname address1
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0address2
>
> 1 =A0 =A0 =A0 =A0aaa =A0 =A0 =A0 =A0 =A0 =A0First Layout,
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 CA, US.
>
> Thanks in advance.
>
> Thanks and Regards,
> Ganapathi sundaram.G
Where do you want to show data?
It seems you should use Reports