将一个MySQL表的ID名称加入另一个MySQL表中的ID(Join ID names of one MySQL table to IDs in another)

将一个MySQL表的ID名称加入另一个MySQL表中的ID(Join ID names of one MySQL table to IDs in another)

我有一个客户端详细信息表，由ID标识，如下所示：

ID (the clientcode), ame, Details

我想从另一个表中引用带有销售信息的ID，并在查询中选择客户端的名称。

我只获取ID（客户端代码）的原始查询字符串是：

SELECT clientcode, SUM(sales) FROM inventory WHERE manufacturer='1' GROUP BY client code ORDER BY SUM(sales) DESC

我还想拿起客户端代码引用的客户端的名称。

我尝试了几个LEFT JOI但无法使查询正常工作。

I have one table of client details identified by an ID that looks like this:

ID (the clientcode), ame, Details

I would like to reference the ID from another table with sales information and pick up the name of the client in the query.

My original query string that picked up just the ID (clientcode) is this:

SELECT clientcode, SUM(sales) FROM inventory WHERE manufacturer='1' GROUP BY client code ORDER BY SUM(sales) DESC

I would like to also pick up the ame of the client referenced by clientcode.

I tried a few LEFT JOIs but couldn't get the queries working.

最满意答案

SELECT , , SUM(i.sales) FROM inventory i LEFT JOI clientdetails c O c.id = WHERE ='1' GROUP BY , ORDER BY SUM(i.sales) DESC SELECT , , SUM(i.sales) FROM inventory i LEFT JOI clientdetails c O c.id = WHERE ='1' GROUP BY , ORDER BY SUM(i.sales) DESC