>Hi everyone,
>
>Do you know, is there a way to add unique identifier in SQL, which operates on several tables.
Hi Nadya
If you don't need them to reflect recno() -- that is you don't care if they contain meaingful info so long as they are unqiue try:
SELECT *, SUBSTR(SYS(2015),2,9) AS id FROM MYTABLE1 inner join mytable2 on mtable1.pk=mytable2.fk into cursor mycursor
Thanks
Gar W. Lipow