Generate a single list from three fields

I have a database table with three columns containing numbers.

Column 1
123
456
789

Column 2
987
654
321

Column 3
24680
13579

Would like to display in one column …

123
456
789
987
654
321
13579
24680

Is this possible?

I might well be missing the point, but can’t you simply put:
{{col1}}<br>{{col2}}<br>{{col3}}
into the single column.

(I’m not sure if you’re referring to database table columns or HTML table columns - but it may not make any difference.)

Ah, yes, its a database table.

But the display part - that’s an HTML table? (I’m not sure if you have a solution yet.)

assuming that the table is a SQL database table to assemble the 3 columns into a single list or column can assembled using a UNION query
select col1 from table1
union
select col2 from table1
union
select col3 from table1

Thanks Jeffrey! I have never used UNION before. I will experiment with that today.

Much appreciated.

That’s already possible using the Server Connect Array List component:

This topic was automatically closed after 26 hours. New replies are no longer allowed.