我在 phpMyAdmin 上运行以下查询
我获得了数据,但是当单击“导出”时,它会重定向到 sql 查询选项卡
Select
sad.firstname,
sad.lastname,
sfo.base_total_invoiced,
sad.email,
sad.telephone,
sad.postcode,
sad.street,
sad.locality,
sad.city
From
sales_flat_order_address sad
Inner join
customer_address_entity cae ON sad.entity_id = cae.entity_id
Inner join
pincode_24_11_2015 pc ON sad.postcode = pc.pincode
Inner join
pincode_city_state_map pcs ON pc.pincode_id = pcs.pincode_id
Inner join
city c on pcs.city_id = c.city_id
Inner join
sales_flat_order sfo on sad.entity_id = sfo.entity_id
Where
sad.city = "Pune"
And
cae.created_at Between "2015-01-01 00:00:00" And "2016-01-07 00:00:00";
有人可以帮忙解决这个问题吗?
删除表别名(使用真实的表名)
SELECT
sales_flat_order_address.firstname,
sales_flat_order_address.lastname,
sales_flat_order.base_total_invoiced,
sales_flat_order_address.email,
sales_flat_order_address.telephone,
sales_flat_order_address.postcode,
sales_flat_order_address.street,
sales_flat_order_address.locality,
sales_flat_order_address.city
FROM sales_flat_order_address
INNER JOIN customer_address_entity
ON sales_flat_order_address.entity_id = customer_address_entity.entity_id
INNER JOIN pincode_24_11_2015
ON sales_flat_order_address.postcode = pincode_24_11_2015.pincode
INNER JOIN pincode_city_state_map
ON pincode_24_11_2015.pincode_id = pincode_city_state_map.pincode_id
INNER JOIN city
ON pincode_city_state_map.city_id = city.city_id
INNER JOIN sales_flat_order
ON sales_flat_order_address.entity_id = sales_flat_order.entity_id
WHERE sales_flat_order_address.city = "Pune"
AND customer_address_entity.created_at BETWEEN "2015-01-01 00:00:00" AND "2016-01-07 00:00:00";
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)