Yes, I could make an identity column - but, I wanted to know if it could be done without one.  Given that row numbers are identical between the tables.  Why...

Yes, the SELECT ROW_NUMBER() function would work - that is what I've been looking for.  It's just too bad I don't have 2005 or I'm gonna have to...

You are correct - there are no pkey's.  This is NOT the column that I will use for joining.  This column that may be used in the query - but...

Thanks but . . . I made a mistake.  The pkey's are not unique.  It is actually a many to many relationship.  But the rows are identical(in order top down & ID's...

Thanks - it works great Noel.  I just changed it a bit . . . column_type to data_type and I don't need the case statement.  And, if you have time...