select a.uid, a.bday, c.uid as friendid, c.bday as friend_bday from members as a join friends as b on a.uid =b.uid join members as c on b.frientid=c.uid where a.uid='xx'
selec bday from members,freinds where members.uid= freinds .uid
select * from members inner join freinds on members.uid = freinds.uid and freindid = '好友id'
#1054 - Unknown column 'b.frientid' in 'on clause'
上面的好像是被吃掉一些空格了? SQL codeselect a.uid, a.bday, c.uidas friendid, c.bdayas friend_bday from membersas a join friendsas b on a.uid=b.uid join membersas c on b.frientid=c.uid where a.uid='xx'
select friendid from friends f join member m on f.uid=m.uid where bday=@name--你的用户
select uid,bday from members where uid in(select freindid from freinds where uid=@uid)
select * from members a,freinds b where a.uid=b.freindid
SELECT m.bday,f.friendid FROM members m JOIN friends ON m.uid = f.uid
a.uid,
a.bday,
c.uid as friendid,
c.bday as friend_bday
from members as a
join friends as b
on a.uid =b.uid
join members as c
on b.frientid=c.uid
where a.uid='xx'
#1054 - Unknown column 'b.frientid' in 'on clause'
SQL codeselect
a.uid,
a.bday,
c.uidas friendid,
c.bdayas friend_bday
from membersas a
join friendsas b on a.uid=b.uid
join membersas c on b.frientid=c.uid
where a.uid='xx'
from friends f join member m on f.uid=m.uid
where bday=@name--你的用户
select * from members a,freinds b where a.uid=b.freindid
FROM members m JOIN friends ON m.uid = f.uid