mysql如何加入两个表?

2021-11-20 00:00:00 sql mysql inner-join

我有两张桌子:

  • id
  • 客户
  • 服务

和

  • id
  • 姓名
  • 电子邮件

如何列出表服务并汇集客户表的客户名称?表中的字段customer services 有customer 表中的customer id，

How to list table service and bring together the customer name that the customers table? field customer services in the table has the id of the customer at the customer table,

感谢您的帮助

推荐答案

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

相关文章