From: "T. H. Grejc" > How can I add more fields to query. If I write: > > SELECT DISTINCT FROM_UNIXTIME(created, '%Y %M'), other_field FROM > table_name ORDER BY created DESC > > I loose distinction (all dates are displayed). > > TNX > I don't think distinction is lost. All the rows should still be distinct (considered in their entirity). What are you expecting to see as a result?
John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]