Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Row to Row join
That's exactly my problem... I don't have a key in the table to go off of. I was hoping MS SQL had something like 'rownum' in Oracle or there was some sort of work around. This is a one to one relationship.- j8slo
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Row to Row join
Well this is just theoretical as what I am doing is quite complicated and more than I can explain here. Ok, lets say table A has a column called 'alpha' and B has column called 'numeric'. Let's also say there is a pseudo-value 'row' which gives the row number in that table. What I am trying to...- j8slo
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Row to Row join
I'm working with MS SQL 2000, I need to join tables A and B to give me table C. How would I write such a query? A B C ----- ----- --------- | a | | 1 | | a | 1 | | b | | 2 | | b | 2 | | c | | 3 | | c | 3 | | d | | 4 | | d | 4 | ----- ----- --------- I...- j8slo
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
