关于 SQL 查询语句 - V2EX

Home Sign Up Sign In

› MySQL 5.5 Community Server

› MySQL 5.6 Community Server

› Percona Configuration Wizard

› XtraBackup 搭建主从复制

Great Sites on MySQL

› MySQL Performance Blog

› Severalnines

推荐管理工具

推荐书目

› MySQL Cookbook

MySQL 相关项目

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 3937 days ago, the information mentioned may be changed or developed.

一个表(client)，俩字段同时关联一个表(user)，一个字段(client.create_user)是记录提交者 ID （ user.user_id)，另一个字段(client.edit_user)是记录修改者 ID(user.user_id);通过 LEFT JOIN 查询，只会显示出一个 user.name,请问这种情况下 SQL 该如何写？

2 replies • 2016-01-08 15:40:10 +08:00

1

ivvei

Jan 8, 2016

left join 两次

2

fising

Jan 8, 2016

SELECT
client.id,
client.create_user,
user.name AS creator,
client.edit_user,
c.name AS editor
FROM
client
LEFT JOIN user client.create_user = user.user_id
LEFT JOIN user AS c ON client.edit_user = c.user_id;

About · Help · Advertise · Blog · API · FAQ · Privacy · Solana · 1195 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 24ms · UTC 23:32 · PVG 07:32 · LAX 16:32 · JFK 19:32
♥ Do have faith in what you're doing.