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.
If it's not broken, fix it until it is.
My Blog