Controlling JOIN Hierarchy in SQL2000 without CTE
Posted on 2008-06-23
I am joining on a set of data in SQL2000, and would like to control the hierarchy of which JOIN is used when given a choice of matches.
I can assign a numeric value to the data set, so I only need to JOIN on the lowest/highest number available.
So for example on the below if joining on the middle column with B, I would want to return 250, not another value.
1 A 150
1 B 250
2 A 330
2 B 558
3 A 554
3 B 447
3 C 557