我有两张表:
服务
和
客户端
名称
的
如何列出表服务并汇集customers表中的客户名称?表中的字段customer services具有customer表中的客户的id,
我现在很感谢你的帮助
发布于 2010-08-21 12:10:51
SELECT * FROM table1 LEFT JOIN table2 on table1.id = table2.id
发布于 2010-08-21 12:11:35
SELECT ...
FROM services AS s
JOIN clients AS c
ON s.client = c.id
WHERE ...
发布于 2010-08-21 12:11:54
SELECT ...
FROM services AS s
INNER JOIN clients AS c
ON s.client=c.id
https://stackoverflow.com/questions/3536283
复制相似问题