语句如下:
select dzh as 读者号,(select dzm from reader where dzh=a.dzh) as 读者名,(select sfz from reader where dzh=a.dzh) as
身份证,(select dh from reader where dzh=a.dzh) as 电话,(select dz from reader where dzh=a.dzh) as 地址 from record as a where ghbj='否' and datediff(dd,jyrq,getdate())>=60
其实这题用Inner Join来做更好,用子查询会大大影响查询速度,不过既然题目是这样出的就这么写吧。