質問編集履歴
1
誤字の修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -5,7 +5,7 @@
|
|
|
5
5
|
update STOCK set stock = stock - #{num} where product_id = #{id};
|
|
6
6
|
</update>
|
|
7
7
|
<select id="getProduct" resultType="ProductEntity">
|
|
8
|
-
select name, stock from PRODUCT_MASTER as p join STOCK as s on p.#{productId} = s.#{
|
|
8
|
+
select name, stock from PRODUCT_MASTER as p join STOCK as s on p.#{productId} = s.#{productId} where p.shop_id = #{shopId} ;
|
|
9
9
|
</select>
|
|
10
10
|
</mapper>
|
|
11
11
|
```
|