MySQL之从一个表中的两个Id分别获取另一个表中对应这两个Id的名字

---

SELECT
    a.senderId,
    b.realname,
    aa.recipientId,
    aa.realname
FROM
    notice a
INNER JOIN USER b ON b.userid = a.senderId
LEFT JOIN (
    SELECT
        a.recipientId,
        b.realname,
        a.`noticeId`
    FROM
        notice a
    INNER JOIN USER b ON b.userid = a.recipientId
) aa ON aa.`noticeId` = a.`noticeId`

---

http://blog.sina.com.cn/s/blog_149e9d2ec0102voyy.html

SELECT DISTINCT
    u.username,
    u.nickname,
    u.mobile,
    c.ydcb,
    uu.username username2,
    uu.mobile mobile2,
    t.trade_id,
    t.coin_type,
    t.trading_amount_old,
    t.trading_amount_now,
    t.fee,
    `addtime`,
    t.remark
FROM
    paymall_trade_records t
LEFT JOIN paymall_user_coin c ON c.userid = t.userid_out
LEFT JOIN paymall_users u ON u.id = t.userid_out
LEFT JOIN paymall_users uu ON uu.id = t.userid_into
WHERE
    (1)
ORDER BY
    t.id DESC
LIMIT 0,
 10