根据第一个结果的uid和第二个结果的user_id合并
查询一:
select uid,photo,online_info
from user_info
where uid in(
select friendid
from friends_info
where uid='terry'
union
select uid
from friends_info
where friendid='terry'
)
查询二:
select user_id,talk_text
from talk_info
where user_id in(
select friendid
from friends_info
where uid='terry'
union
select uid
from friends_info
where friendid='terry'
)order by id desc limit 1
查询一:
select uid,photo,online_info
from user_info
where uid in(
select friendid
from friends_info
where uid='terry'
union
select uid
from friends_info
where friendid='terry'
)
查询二:
select user_id,talk_text
from talk_info
where user_id in(
select friendid
from friends_info
where uid='terry'
union
select uid
from friends_info
where friendid='terry'
)order by id desc limit 1