Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kaustubh
Starting Member
4 Posts |
 Posted - 2005-06-13 : 10:39:36
|
| Hey!I have a view which returns me a column (lets say colA) with values like 0.85, 1.95, 1.09 etc.Then i have a table which contains a RangeId's for colA values, with ranges like..RangeID colA_UpperLimit colA_LowerLimit01 0.50 1.5002 1.51 2.0103 2.02 3.52How do i get the colA values with the corresponding RangeId's in one view?There is no relation between the two tables.I have already tried the following:SELECT T.RangeID, V.ColAFROM viewColA V LEFT JOIN tableRange T ON V.ColA BETWEEN T.colA_UpperLimit AND T.colA_LowerLimitI get a violation error.Looking forward to a reply.Thanks everyone!KaustubhThere is no unanswered reply! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Joining two unrelated tables