I have this table: mysql> select historyvlan_time, historyvlan_vlan, v.clienthistory_id from pe_historyvlan as v join pe_clienthistory using (clienthistory_id) order by historyvlan_vlan, historyvlan_time desc; +------------------+------------------+------------------+ | historyvlan_time | historyvlan_vlan | clienthistory_id | +------------------+------------------+------------------+ | 0503011446 | 4 | 55 | <-- | 0503011440 | 4 | 54 | | 0502181640 | 4 | 29 | | 0502181638 | 4 | 26 | | 0502181508 | 4 | 24 | | 0503021500 | 5 | 73 | <-- | 0503011808 | 6 | 71 | <-- | 0503011452 | 6 | 56 | | 0502181626 | 6 | 25 | | 0502181640 | 7 | 28 | <-- | 0503011805 | 8 | 70 | <-- | 0503011801 | 8 | 68 | | 0503011731 | 8 | 61 | | 0503011730 | 8 | 60 | +------------------+------------------+------------------+ 14 rows in set (0.00 sec)
I am trying to find the id and vlan for the most recent time: mysql> select max(historyvlan_time), historyvlan_vlan, v.clienthistory_id from pe_historyvlan as v join pe_clienthistory using (clienthistory_id) group by historyvlan_vlan order by historyvlan_vlan, historyvlan_time desc; +-----------------------+------------------+------------------+ | max(historyvlan_time) | historyvlan_vlan | clienthistory_id | +-----------------------+------------------+------------------+ | 0503011446 | 4 | 24 | <-- | 0503021500 | 5 | 73 | | 0503011808 | 6 | 25 | <-- | 0502181640 | 7 | 28 | | 0503011805 | 8 | 60 | <-- +-----------------------+------------------+------------------+ 5 rows in set (0.00 sec) Why do I get '24' when I should get '55', '25' when I should get '61', and '60' when I should get '70'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
