Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE Store,(SELECT avg(Review.star) AS a, sId
- FROM Review GROUP BY sId) b2
- SET Store.star = b2.a
- WHERE b2.sId=Store.sId AND city='Taipei' AND address LIKE '%大安區%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement