mysql - 从左到右加入的正确方法是什么？

Question

我正在尝试从数据库中获取数据，但以这种方式获取数据时遇到问题

|42|127-1|COMPANY LTDA|ORLANDO |MIT|91919191|Address 1
|42|127-1|COMPANY LTDA|ORLANDO |MIT|92929292|Address 2

我做了两个LEFT JOIN从客户那里得到地址和电话。

这是我的查询：

SELECT cl.*,phone.c_phone_client,address.c_address_client
FROM  c_client AS cl 
  LEFT JOIN c_client_phone_fk AS phone ON phone.c_id_client = cl.c_id_client
  LEFT JOIN c_client_address_fk AS address ON phone.c_id_client = cl.c_id_client
 WHERE cl.c_id_client='127-1' 
 GROUP BY phone.c_phone_client,address.c_address_client
 ORDER BY address.c_address_client

通过这个查询，我得到了这个结果：

|42|127-1|COMPANY LTDA|ORLANDO|MIT|91919191|Address 1
|42|127-1|COMPANY LTDA|ORLANDO|MIT|92929292|Address 1
|42|127-1|COMPANY LTDA|ORLANDO|MIT|91919191|Address 2
|42|127-1|COMPANY LTDA|ORLANDO|MIT|92929292|Address 2

如何修复我的查询？

标签： mysqlsql