如果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