subject:"UPDATE ... where max\(datecolumn\)"

Re: UPDATE ... where max(datecolumn)

2009-01-31 Thread Baron Schwartz

Is there ever more than one order per day? I also think you might mean "most current order per product", but you didn't say that. On Tue, Jan 27, 2009 at 8:38 AM, Adria Stembridge wrote: > I have a table like this: > > ID PRODUCT DATEORDERED > 152005-02-18 > 22

UPDATE ... where max(datecolumn)

2009-01-27 Thread Adria Stembridge

I have a table like this: ID PRODUCT DATEORDERED 152005-02-18 222008-03-13 322008-11-21 462009-01-21 A field has been added for current order to this table: ID PRODUCT DATEORDERED FLAGCURRENT I need to update