Result on a single line

#1

Hi,

Using MS Query, I like to query an Informix database and get the result of
multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows like
this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#2

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#3

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#4

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#5

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#6

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#7

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#8

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#9

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3

#10

Thanks for replying but it doesn't work. I got an error message. I think it
doesn't like the + sign...
Here is the query:

SELECT inv2.in2_in1_code, inv2.in2_loc_mag, inv2.in2_en1_code, loc1.lc1_loc,
loc1.lc1_seq, loc1.lc1_date
FROM prog.inv2 inv2, prog.loc1 loc1
WHERE loc1.lc1_en1_code = inv2.in2_en1_code AND loc1.lc1_in1_code =
inv2.in2_in1_code AND ((inv2.in2_en1_code='3') AND
(inv2.in2_in1_code='2001492'))

loc1.lc1_loc is the column that we need the data to show on several columns.

Amiro

"Rubén Garrigós" <rgarrigos (AT) solidq (DOT) com> a écrit dans le message de news:
OjXCY3MwIHA.524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

You can concatenate the columns with:

select col1, col2, col31 + col32 + col33 as col3 from...

--
Rubén Garrigós
Solid Quality Mentors

"Amiro" <Amiro (AT) amiro (DOT) com> wrote in message
news:OHh9JdMwIHA.5580 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

Using MS Query, I like to query an Informix database and get the result
of multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows
like this

Col 1 - Col 2 - Col 3 - Col 3 - Col 3 - Col 3
data data data1 data2 data3 data4

Instead of

Col 1 - Col 2 - Col 3
data data data1
data2

Can I do that in MS Query?

Thanks in advance.

Amiro
data3