>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