if this were a simple table, than a AutoInc PK could be used, but its a view formed by unions and joins from a number of tables, but I need each resulting record to have a sequential ID number
CREATE VIEW myVIEW AS SELECT DISTINCT f1,f2,f3, [SOME WAY TO NUMBER THE RECORD]
FROM (
(<select stuff>) UNION (select stuff) UNION (<select more stuff)
and some of those have LEFT JOINS in them
Records will be selected based on F1, F2 OR F3, and the ID number is required.