JOINON 怎么实现?

Topics: Developer Forum, Project Management Forum, User Forum
Jul 8, 2012 at 4:21 AM
Edited Jul 8, 2012 at 4:22 AM

SELECT a.id,a.MemberNumber,a.Email,a.RealName,b.id,b.MemberNumber,b.Email,b.RealName FROM ((MemberFriend as c LEFT JOIN Member as a ON a.id = c.MemberId) LEFT JOIN  Member as b ON c.FriendMemberId = b.id)  WHERE (c.MemberId=2 or c.FriendMemberId=2)

 

我这样的语句用JOIN TABLE怎么实现,一个表中的两个字段是会员表的ID值;;

Coordinator
Jul 10, 2012 at 5:58 AM

如果实现的功能比较复杂,或者DbEntry没事内置实现,可以直接使用SQL。