Re: SQL Question

hello- you can try the following. not sure if it will work but it's definitely worth a shot. create a sequence (say MySeq) and add the sequence to the select statement. for example, select MySeq.nextval, .... from table; the sequence must be reinitialized to 1 before any new query so it's more like.. drop sequence MySeq; create sequence MySeq start with 1 increment by 1; select MySeq.nextval, .... from table; this is a proposed solution for oracle. may/may not work with other databases. let me know if it works. -- krishnan