select * ,goods_id as g_id, (select min(sale_price) from wsj_goods_spec where sale_state=1 and sale_price>0 and goods_id=g_id) as sale_price , (select min(price) from wsj_goods_spec where sale_state=0 and goods_id=g_id) as price from wsj_goods where 1

目前我只能用query