temp
2015-11-29 本文已影响45人
wjing
wine_ids:2,4,5,6,7,8,14,22,23,24
menu_ids:17,18,19
SELECT wine_set.wine_id, wine_set.wine_num*menu_set.set_num from wine_set join menu_set on menu_set.set_id = wine_set.set_id where menu_set.menu_id in (select menu_id from menu where bar_id = ? and menu_status = ? ) group by wine_id
http://pan.baidu.com/s/1qYCvZic
