With a plug for Bill Downall and David Blocker's excellent "Advanced SQL" book which, to this day, remains a very valuable resource and is not routinely included in the resources for R:BASE. I've searched for an hour, both in the book and in my email Rbase-l archives.
I'm looking for that special UNION statement (Bill, are you there?) to create a sequence numbering on the fly. TIA, Claudine

