* Ville Mattila > I have a table containing weather reports of different types and cities. > The structure is following: > - type > - city > - time > - report > > Which kind of query should I use to select the latest reports of > specified cities. I mean, if I had three different types of reports for > Helsinki and Turku, how can I get them all in one query?
Use a sub-select if you can, or see the MAX-CONCAT trick: <URL: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]