| Subject | Multiple LIST columns |
|---|---|
| Author | Daniel Miller |
| Post date | 2017-09-28T05:26:31Z |
With a statement such as:
select n.NODE, h.ROUTE_UPDATED,
list( h.ROUTE_INDEX ) LI, list( h.LINK_NODE ) LN, list( h.QUALITY ) LQ
from NODES n
join ROUTE_HISTORY h on n.NODE=h.NODE
where n.NODE=5104
group by n.NODE, h.ROUTE_UPDATED
order by h.ROUTE_UPDATED desc
list( h.ROUTE_INDEX ) LI, list( h.LINK_NODE ) LN, list( h.QUALITY ) LQ
from NODES n
join ROUTE_HISTORY h on n.NODE=h.NODE
where n.NODE=5104
group by n.NODE, h.ROUTE_UPDATED
order by h.ROUTE_UPDATED desc
Are the LISTS guaranteed to be in matching order? So each entry of each comma-delimited list is pulled from the same row as the corresponding entry in the other lists?
--
Daniel