mysql如何连接两个表？

Question

我有两个表：

services

• id
• client
• service

和

clients

• id
• name
• email

如何列出表服务并将客户表中的客户名称汇总在一起？表中的字段客户服务有客户表中客户的 id，

非常感谢您现在的帮助

Answer 1

SELECT * FROM table1 LEFT JOIN table2 on table1.id = table2.id

Answer 2

SELECT ...
FROM services AS s
JOIN clients AS c
  ON s.client = c.id
WHERE ...

Answer 3

SELECT ...
FROM services AS s
INNER JOIN clients AS c
  ON s.client=c.id

Answer 4

试试这个，

SELECT * from services as s INNER JOIN clients as c on s.id=c.id