Hi everyone,

Do you know, is there a way to add unique identifier in SQL, which operates on several tables. I know, it could be done on one table:
select recno() as RecNum, * from MyTable into table OutTable
or it could be done in 2 steps for multiple tables:
select * from MyTable1 inner join MyTable2 on MyTable1.Pk=MyTable2.Fk into cursor MyCursor
select recno() as RecNum, * from MyCursor into table OutTable.

My question is: can we combine these two steps into one?

Thanks in advance.