Changeset 12023 for branches/dev/html/admin/total/index.php
- Timestamp:
- 2007/03/29 14:30:03 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/admin/total/index.php
r12022 r12023 625 625 $sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE $where ) "; 626 626 $sql.= "GROUP BY product_id, product_code, price "; 627 $sql.= ") ";627 $sql.= ") AS T1 "; 628 628 $sql.= "ORDER BY T1.total DESC "; 629 629
Note: See TracChangeset
for help on using the changeset viewer.