如果model_name和model匹配,我将如何在连接表上合并结果?

表:tw

model
customer_name

表:模型

model_name
quantity

SQL:

SELECT DISTINCT model.model_quantity, model.model_name, tw.customer_name, tw.model FROM tw
RIGHT OUTER JOIN model
ON model.model_name=tw.model
AND tw.completed = 1 AND tw.stock = 0
ORDER BY model.id

我已将数组信息显示为显示目的,希望它有助于理解合并需要如何发生 .

目前:

STC5
0
Andy Baker
Array ( [model_quantity] => 0 [model_name] => STC5 [customer_name] => Andy Baker [model] => STC5 ) 

STC5
0
Richard Cash
Array ( [model_quantity] => 0 [model_name] => STC5 [customer_name] => Richard Cash [model] => STC5 )

预期结果一列包含匹配模型的所有名称列表:

STC5
0
Andy Baker
Richard Cash