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
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