mysqlÖеÄËıíÁªºÏ²éѯÎÊÌâ

SQL code:

ÓÐËÄÕűí
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'

µ«Êý¾ÝÈ¡³öÓÐÎÊÌ⣬ÎÞ·¨ÕýÈ·È¡³öÊý¾Ý
ÇëÎÊ£¬ÎÊÌâ³öÔÚÄÄ£¿ÈçºÎ½â¾ö£¬Ð»Ð»£¡

---

È¥µô¿ÕÖµ

---

Ó﷨û´í.

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'

ÊDz»ÊÇȷʵ¾ÍûÊý¾Ý

---

ÓÐÊý¾Ý£¬µ«È¡³öµÄÊý¾Ý²»ÕýÈ·

---

mysql ²»¶®

---

ÎÒ½¨ÒéÄãÒ»¶ÎÒ»¶ÎµÄÊÔ,¿´Ã«²¡µ½µ×ÔÚÄÄÀï?

ÀýÈç:
SELECT f.uid,f.fusername,  s.namestatus, s.groupid
from uchome_friend f
      left join space s