I believe you are at minimum talking about a subselect command here. I am just about to get the idea what you really want. You want to request all updated prices f.e. to show a pricelist with the newest prices.
I guess thats to high for me to reach right now - but definitely interesting ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 2日 月曜日 08:55、Mateusz さんは書きました: > > SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC > > LIMIT > > > 1; > > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date > > that > > > the record was inserted > > This would only select one row (the most recent). I need a set of rows, one > for _each_ type of food (one and only one for tomatoes, one and only one > for potatoes and so on). > > Mateusz Uzdowski -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
