求一条查找2个表中的满足条件的语句,把满足条件的记录读取出来表a
pageid link click addtime
1 www.sina.com 5 2006-12-9
1 www.163.com 8 2006-12-9
2 www.88888.com 1 2006-12-9
1 www.tom.com 7 2006-12-8
3 www.121212.com 2 2006-12-9表bpageid link click addtime
1 www.sohu.com 3 2006-12-9
1 www.mop.com 8 2006-12-9
2 www.666666.com 1 2006-12-9
1 www.tom.com 7 2006-12-8
3 www.555555.com 2 2006-12-9现在求一条sql语句,把这两个表中的所有满足当天的pageid=1的记录读取出来
结果应该是:
pageid link click addtime
1 www.sina.com 5 2006-12-9
1 www.163.com 8 2006-12-9
1 www.sohu.com 3 2006-12-9
1 www.mop.com 8 2006-12-9这个sql该怎么写??请教大家~~~~~~~~
pageid link click addtime
1 www.sina.com 5 2006-12-9
1 www.163.com 8 2006-12-9
2 www.88888.com 1 2006-12-9
1 www.tom.com 7 2006-12-8
3 www.121212.com 2 2006-12-9表bpageid link click addtime
1 www.sohu.com 3 2006-12-9
1 www.mop.com 8 2006-12-9
2 www.666666.com 1 2006-12-9
1 www.tom.com 7 2006-12-8
3 www.555555.com 2 2006-12-9现在求一条sql语句,把这两个表中的所有满足当天的pageid=1的记录读取出来
结果应该是:
pageid link click addtime
1 www.sina.com 5 2006-12-9
1 www.163.com 8 2006-12-9
1 www.sohu.com 3 2006-12-9
1 www.mop.com 8 2006-12-9这个sql该怎么写??请教大家~~~~~~~~
where pageid=1
union all
select * from b
where pageid=1
where pageid=1
and datediff(day,addtime,getdate())=0
union all
select * from b
where pageid=1
and datediff(day,addtime,getdate())=0
union all
select * from 表b where pageid=1 and addtime=substring(convert(char(8),getdate(),120))
我没理解错吧,不难的吧!
union all
select * from 表b where pageid=1 and addtime=substring(convert(char(8),getdate(),120),1,8)