Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MySQL Query Help
Thanks for all the help guys! I finally have the correct SQL statement: mysql> select distinct order_id, max(memo_id), memo_time, status_id, memo_read -> FROM order_memo -> GROUP BY order_ID -> ORDER BY order_id ASC , memo_id DESC -> LIMIT 10 ... -
MySQL Query Help
Yeah i need the max memo_id from every order_id, that's becasuse i need to make a mailing every night to the admins, office and manufactors (where the order_id is assigned to) so they know the last status (at the last memo_id). -
MySQL Query Help
Hi Bastien, Here is my SQL Result. mysql> select distinct(order_id),memo_id ,memo_time, status_id, memo_read -> FROM order_memo -> ORDER BY order_id ASC , memo_id DESC -> LIMIT 10; +----------+---------+---------------------+-----------+-----------+ | order_id | memo_id |... -
-
MySQL Query Help
SELECT DISTINCT ( order_id ), * FROM `order_memo` ORDER BY order_id ASC , memo_id DESC LIMIT 10 MySQL retourneerde: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `order_memo` ORDER BY... -
MySQL Query Help
Hi Everyone. I have the following situation: TABLE: order_memo mysql> SELECT * FROM `order_memo` ORDER BY `order_id` LIMIT 10; +----------+---------+---------------------+-----------+-----------+ | order_id | memo_id | memo_time | status_id | memo_read |...
