sql级联查询案例一则

2014-11-24 01:41:52 · 作者: · 浏览: 7

例子:

Tab1:id,name,pass...

Tab2:sn,tel,address...

Tab1 里的id 与 Tab2里的sn对应。

查询语句

select * from Tab1 as t1 join Tab2 as t2 on t1.id=t2.sn

这样查询出来会有重复,看下面这句

select top 10 id,name,pass,tel from Tab1 join Tab2 on Tab1.id=Tab2.sn where date_post between 2009/7/14 and 2009/10/21 group by Tab1.id,name,pass,Tab2.tel