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 请问这个语句哪里有问题???
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