select t1.* from (select * from diary where adddate>=dateadd(d,-3,getdate()) union select id,'心情',username,content,adddate from heart where adddate>=dateadd(d,-3,getdate()) ) t1 inner join firend t2 on t1.firendusername=t2.firendusername
select t1.* from (select title,username,adddate from diary where adddate>=dateadd(d,-3,getdate()) union select content,username,adddate from heart where adddate>=dateadd(d,-3,getdate()) ) t1 inner join firend t2 on t1.firendusername=t2.firendusername
diary表:字段 id,title(标题),username(作者),content(内容),adddate(添加日期)
heart表:字段 id,content(内容), username(作者),adddate(添加日期)
diary表:字段 id,title(标题),username(作者),content(内容),adddate(添加日期)
heart表:字段 id,content(内容), username(作者),adddate(添加日期)
(select * from diary where adddate>=dateadd(d,-3,getdate())
union
select id,'心情',username,content,adddate from heart where adddate>=dateadd(d,-3,getdate()) ) t1
inner join firend t2 on t1.firendusername=t2.firendusername
(select title,username,adddate from diary where adddate>=dateadd(d,-3,getdate())
union
select content,username,adddate from heart where adddate>=dateadd(d,-3,getdate()) ) t1
inner join firend t2 on t1.firendusername=t2.firendusername