php - MySql 从一个 id 中获取两个值

Question

我在下面有这个 sql 查询，注意字段 receiver 从 table_1

返回 id

我的问题是如何在 receiver 点获取接收者 FirstName 和 LastName？

SELECT DISTINCT
    FirstName, 
    LastName, 
    table_2.status, 
    (select FirstName, LastName from table_1 where table_1.id = table_2.receiver) as receiver 
FROM table_1
INNER JOIN 
    table_2 on table_1.key_2 = CONCAT('OFFLINE-', table_2.id)
ORDER BY FirstName, LastName

我在我的 SQL 中添加了一个子查询，但这给了我一个语法错误:(

Answer 1

select distinct FirstName, LastName, table_2.status, CONCAT(FirstName, ' ', LastName) 
from table_1 inner join table_2 on table_1.key_2 = CONCAT('OFFLINE-', table_2.id) 
order by FirstName, LastName