本帖最后由 Green_leaves 于 2012-6-15 19:19 编辑
select ecs_order_info.order_id,ecs_order_info.consignee,ecs_order_info.tel,ecs_order_info.mobile,ecs_order_goods.goods_name,ecs_order_goods.goods_price,(select region_name from ecs_region where region_id=ecs_order_info.province) as sheng,(select region_name from ecs_region where region_id=ecs_order_info.city) as chengshi,(select region_name from ecs_region where region_id=ecs_order_info.district) as diqu,ecs_order_info.address,ecs_order_info.zipcode,ecs_order_info.email,ecs_order_info.best_time,ecs_order_info.goods_amount,ecs_order_info.add_time,from_unixtime(ecs_order_info.add_time) as time from ecs_order_info left join ecs_order_goods on ecs_order_goods.order_id=ecs_order_info.order_id where ecs_order_goods.goods_id in(6615,6614)今天研究了半天,终于搞出来这个语句。
尼玛,我不是数据库攻城师啊,数据库根本不懂啊。尼玛,成千上万的数据,看着一头浆糊啊。百度google了好长时间啊,摸索的半天啊。贡献出来大家都来用一用吧。
各位兄弟们,你们的sql语句有多长,也来晒一晒