本文介绍了MySQL按索引ID从单独的表中排序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我遇到了一个我确定很容易实现的问题.我有一张桌子可以买一些商品.它包含所有信息,包括制造商的ID.有关制造商的信息在单独的表格中.用户搜索时,他们具有过滤器选项.我遇到问题的是由制造商进行过滤.
I have run into a problem that I'm sure is easy to achieve. I have a table for some merchandise. It holds all the information including the id for the manufacturer. The information about the manufacturer is in a separate table. When users are searching they have filter options. The one I'm having trouble with is filtering by manufacturer.
Products Table: cs_products id | name | manufacturer_id --------------------------- 1 | mic | 3 2 | cable | 2 3 | speaker | 1 Manufacturer Table: cs_manufacturer id | name ------------------ 1 | JBL 2 | Rapco 3 | Shure运行查询时,我需要按cs_manufacturer.name排序:
When the query is ran I need to ORDER BY cs_manufacturer.name:
mysql_query("SELECT * FROM cs_products ORDER BY cs_manufacturer.name")正确的语法是什么?
推荐答案SELECT * FROM cs_products JOIN cs_manufacturer ON cs_product.manufacturer_id = cs_manufacturer.id ORDER BY cs_manufacturer.name
更多推荐
MySQL按索引ID从单独的表中排序
发布评论