Hi Gar,

That's probably it. I actually need an Integer identifier, so I'll do val(substr(sys(2015,2,9)).

Thanks a lot. I'll give it a try.

>>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
>