mysql两个表之间的查询

发布网友发布时间：2022-04-15 16:45

共3个回答

懂视网时间：2022-04-15 21:06

bitsCN.com
SELECT c.id, c.order_id, c.title, c.content, c.create_time, o.last_pic FROM `orders` o , `case` c WHERE c.order_id = o.order_id ORDER BY c.id DESC LIMIT 15;

关于跨表提取字段的方法！
利用order_id相同字段，提取case中的id,order_id,title,content,create_time；orders表中的last_pic字段
bitsCN.com

热心网友时间：2022-04-15 18:14

select shop_id,shop_name,sales from t2 inner join t1 on t2.shop_id = t1.shop_id order by sales desc limit 2;追问1052 - Column 'shop_id' in field list is ambiguous；报了这个错误，
还有就是t2中有shop_id相同的是不是要group by一下，然后再把表连接起来？

热心网友时间：2022-04-15 19:32

SELECT
t1.shop_id,
SUM(t2.sales)
FROM
t1  JOIN  t2
    ON  ( t1.shop_id  =  t2.shop_id )
GROUP BY
t1.shop_id
ORDER BY
SUM(t2.sales)  DESC
LIMIT 2