用于获取MySQL,mysql – 用于获取朋友名称的SQL表达式

我正在使用SQL来获取朋友网络功能.我使用了以下代码：

SELECT relationship.requester,

relationship.requested,

user.firstname,

user.lastname

FROM relationship

JOIN user ON (user.guid = relationship.requester

OR user.guid = sqrelationship.requested)

WHERE relationship.requester = {$userid}

OR relationship.requested = {$userid}

AND relationship.approved = 1

SQL将返回一个表,其中包含用户启动或接收的已批准关系的ID.但是,user.firstname和user.lastname只返回一组结果.如何使此表达式能够同时获取请求者和请求者的姓名？

解决方法:

很难说明你没有指定表格设计的问题,但我猜是这样的：

select relationship.requester, relationship.requested,

requester.firstname, requester.lastname,

requested.firstname, requested.lastname,

from relationship

left join user as requester on user.guid = relationship.requester

left join user as requested on user.guid = relationship.requested

where relationship.requester = {$userid}

and relationship.approved = 1

标签：mysql,sql

来源： https://codeday.me/bug/20190709/1414352.html