Selecting multi columns into one ?

[Gurra]

I have 3 tables with an ip column that i would like to get into 1 coloumn
with an query

Table 1 columns
ID, IP
Table 2 & 3 columns
FROMID, IP

I would like all ip columns in one column where id or fromid = 1

is that possible ? or could i use a view to make it easier ?

Thanks
/Gustaf

[Ray at]

SELECT [col1]+[col2]+[col3] FROM ..."

rs.fields.item(0).value would be how to retreive it.

Or, for the slightly more coder-friendly way:

SELECT [col1]+[col2]+[col3] As [TheCols] FROM ..."

rs.fields.Item("TheCols").Value


If the columns are different datatypes, there may be more to it than those
examples though. We'd have to know what kind of database you're using to
help with handling conversions though, I'd imagine.

Ray at work


"Gurra" <gurgel@telia.com> wrote in message
news:%23RGyslI$DHA.2412@TK2MSFTNGP12.phx.gbl...

> I have 3 tables with an ip column that i would like to get into 1 coloumn
> with an query
>
> Table 1 columns
> ID, IP
> Table 2 & 3 columns
> FROMID, IP
>
> I would like all ip columns in one column where id or fromid = 1
>
> is that possible ? or could i use a view to make it easier ?
>
> Thanks
> /Gustaf
>
>

[Jeff Cochran]

On Thu, 26 Feb 2004 17:56:00 +0100, "Gurra" <gurgel@telia.com> wrote:

>I have 3 tables with an ip column that i would like to get into 1 coloumn
>with an query
>
>Table 1 columns
>ID, IP
>Table 2 & 3 columns
>FROMID, IP
>
>I would like all ip columns in one column where id or fromid = 1
>
>is that possible ? or could i use a view to make it easier ?

A view might be easier, or you can do a SELECT AS. Something like:

SELECT Table1.IP, Table2.IP, Table3.IP AS IPAddresses
WHERE Table1.ID = 1 OR Table2.FROMID = 1 OR Table3.FROMID = 1

If the data types are different between columns you'll have a problem
with this, so then you'd have to retrieve the data set and concatenate
it in your code.

Of course, your display of the recordset would use the IPAddresses
alias instead of a column name. :)

Jeff

[Aaron Bertrand [MVP]]

> SELECT Table1.IP, Table2.IP, Table3.IP AS IPAddresses

I think you meant

SELECT Table1.IP + Table2.IP + Table3.IP AS IPAddresses

or maybe

SELECT Table1.IP + ',' + Table2.IP + ',' + Table3.IP AS IPAddresses


....A

[Jeff Cochran]

On Fri, 27 Feb 2004 00:56:20 -0500, "Aaron Bertrand [MVP]"
<aaron@TRASHaspfaq.com> wrote:

>> SELECT Table1.IP, Table2.IP, Table3.IP AS IPAddresses

>
>I think you meant
>
>SELECT Table1.IP + Table2.IP + Table3.IP AS IPAddresses

Yup. Gotta remember to think about what I'm doing. :)

Jeff

[Gurra]

Thanks ! :)

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> skrev i
meddelandet news:u3jZGPJ$DHA.3772@TK2MSFTNGP11.phx.gbl...

> SELECT [col1]+[col2]+[col3] FROM ..."
>
> rs.fields.item(0).value would be how to retreive it.
>
> Or, for the slightly more coder-friendly way:
>
> SELECT [col1]+[col2]+[col3] As [TheCols] FROM ..."
>
> rs.fields.Item("TheCols").Value
>
>
> If the columns are different datatypes, there may be more to it than those
> examples though. We'd have to know what kind of database you're using to
> help with handling conversions though, I'd imagine.
>
> Ray at work
>
>
> "Gurra" <gurgel@telia.com> wrote in message
> news:%23RGyslI$DHA.2412@TK2MSFTNGP12.phx.gbl...

> > I have 3 tables with an ip column that i would like to get into 1

coloumn

> > with an query
> >
> > Table 1 columns
> > ID, IP
> > Table 2 & 3 columns
> > FROMID, IP
> >
> > I would like all ip columns in one column where id or fromid = 1
> >
> > is that possible ? or could i use a view to make it easier ?
> >
> > Thanks
> > /Gustaf
> >
> >

>
>

[Gurra]

Thanks ! :)


"Jeff Cochran" <jcochran.nospam@naplesgov.com> skrev i meddelandet
news:403f4b3e.1358049952@msnews.microsoft.com...

> On Fri, 27 Feb 2004 00:56:20 -0500, "Aaron Bertrand [MVP]"
> <aaron@TRASHaspfaq.com> wrote:
>

> >> SELECT Table1.IP, Table2.IP, Table3.IP AS IPAddresses

> >
> >I think you meant
> >
> >SELECT Table1.IP + Table2.IP + Table3.IP AS IPAddresses

>
> Yup. Gotta remember to think about what I'm doing. :)
>
> Jeff