how to join this two table - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how to join this two table

Author

Topic

jeff06
Posting Yak Master

166 Posts

Posted - 2009-05-05 : 16:01:31

t1

var
1
12
31
11
23

2
low high description
1 10 des1
11 20 des2
21 30 des3

---

I want ret table

var des
1 des1
12 des2
31 des3
11 des2
23 des3
Thanks.

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-05-05 : 16:12:21

on t1.var between t2.low and t2.high

sajeev4evr
Starting Member

5 Posts

Posted - 2009-05-06 : 07:07:37

WHT is this

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources