SELECT `1_sale_orders`.*,sum(`quantity_purchased`),`1_product`.`description` FROM `1_sale_orders` t,`1_product` WHERE `1_sale_orders`.`number`=110 AND 1<(SELECT count(*) from `1_sale_orders` where `number` =110 and `recipient_name`=t.`recipient_name` AND `ship_address_1`=t.`ship_address_1`) AND `1_sale_orders`.`package_area`='SZ' AND `1_sale_orders`.`item_code`=`1_product`.`item_code` GROUP BY `item_code` ORDER BY `item_code` ASC 请问这个语句哪里有问题???
解决方案 »
- 请问mysql-bin.000001这类文件能删除吗?
- MySql中简体和繁体的问题。
- 这个查询语句怎么写?
- 关于load data local 问题?
- mysql双机互备日志处理
- 帮帮忙,好吗?
- 库时存有一字段是datetime类型,如2000-010-02 11:22:05,只取出2000-010-02,在sql语句中怎么写?
- 请问mysql怎么用dos命令打开服务和关闭服务
- mysql(++) 菜鸟问题:
- 【求助】Navicat premium导入Exel丢了2000行
- SQL优化 ,麻烦大大帮忙
- 在系统变量未做调整,数据库连接数一般不超过50的情况下,MySQL内存占用为何会逐日增加?
FROM `1_sale_orders` t,`1_product`
WHERE `1_sale_orders`.`number`=110
AND 1<(SELECT count(*)
from `1_sale_orders`
where `number` =110
and `recipient_name`=t.`recipient_name`
AND `ship_address_1`=t.`ship_address_1`)
AND `1_sale_orders`.`package_area`='SZ'
AND `1_sale_orders`.`item_code`=`1_product`.`item_code`
GROUP BY `item_code`
ORDER BY `item_code` ASC
FROM `1_sale_orders` t,`1_product`
WHERE `1_sale_orders`.`number`=110
AND 1<( SELECT count(*)
from `1_sale_orders`
where `number` =110
and `recipient_name`=t.`recipient_name`
AND `ship_address_1`=t.`ship_address_1`)
AND `1_sale_orders`.`package_area`='SZ'
AND `1_sale_orders`.`item_code`=`1_product`.`item_code`
GROUP BY `item_code`
ORDER BY `item_code` ASC
#1051 - Unknown table '1_sale_orders'表名是对的啊,请问哪里错了??
FROM `1_sale_orders`,`1_product`
WHERE `1_sale_orders`.`number`=110
AND `1_sale_orders`.`package_area`='SZ'
AND `1_sale_orders`.`item_code`=`1_product`.`item_code`
GROUP BY `item_code`
ORDER BY `item_code` ASC这样就可以,不加那个t就可以
FROM `1_sale_orders` t,`1_product`
WHERE t.`number`=110
AND 1<(
SELECT count(*)
from `1_sale_orders`
where `number` =110
and `recipient_name`=t.`recipient_name`
AND `ship_address_1`=t.`ship_address_1`
)
AND t.`package_area`='SZ'
AND t.`item_code`=`1_product`.`item_code`
GROUP BY `item_code`
ORDER BY `item_code` ASC