有四张表
1.friend 字段 uid,fid,friendname
2.space 字段 uid,name
3.spacefield 字段 uid,mobile
4.spaceinfo 字段 uid,title
现在我想通过uid获取这四张表中的同个uid的数据,即获取
friend表中的fid,friendname,space表中的name,spacefield表中的uid,mobile,spaceinfo表中的title等数据以下是我写的联合查询语句
SELECT f.uid,f.fusername, s.namestatus, s.groupid,sf.mobile,si.title FROM uchome_friend f
left join space s on f.uid=s.uid
left join spacefield sf on f.uid=sf.uid
left join spaceinfo si on f.uid=si.uid
WHERE s.uid='1' AND f.status='1'但数据取出有问题,无法正确取出数据
请问,问题出在哪?如何解决,谢谢!
left join space s on f.uid=s.uid
left join spacefield sf on f.uid=sf.uid
left join spaceinfo si on f.uid=si.uid
WHERE s.uid='1' AND f.status='1'是不是确实就没数据
SELECT f.uid,f.fusername, s.namestatus, s.groupid
FROM uchome_friend f
left join space s on f.uid=s.uid
WHERE s.uid='1' AND f.status='1'...SELECT f.uid,f.fusername, s.namestatus, s.groupid,sf.mobile
FROM uchome_friend f
left join space s on f.uid=s.uid
left join spacefield sf on f.uid=sf.uid
WHERE s.uid='1' AND f.status='1'...SELECT f.uid,f.fusername, s.namestatus, s.groupid,sf.mobile,si.title FROM uchome_friend f
left join space s on f.uid=s.uid
left join spacefield sf on f.uid=sf.uid
left join spaceinfo si on f.uid=si.uid
WHERE s.uid='1' AND f.status='1'