Stuart Do you mean you need to explode them, but not sort them?
If so, use an SQL UNNEST keyword, e.g. SELECT SURNAME,FORENAME,TITLE_ID,QTY,PRICE FROM UNNEST BOOK_SALES ON SALE_ITEMS; You can explode a field to a select list by using the TO SLIST clause, e.g. SELECT TITLE_ID TO SLIST 0 FROM UNNEST BOOK_SALES ON SALE_ITEMS; Regards Brian ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
