I have a table like this +-----------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+----------------+ | id | int(3) | | PRI | NULL | auto_increment | | idTable | int(3) unsigned | | | 0 | | | title | varchar(150) | YES | | NULL | | | description | varchar(150) | YES | | NULL | | | date | datetime | YES | | NULL | | +-----------+---------------------+------+-----+---------+----------------+
Is there anyway to make select command like this in Mysql 4.0: select * from #temp where cod in (select max(cod) from #temp group by idtable) order by data desc could someone help me? thanks Fernando -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
