I have a table like this:|
balance keepplace startdate ___________________________________ A01 floor 1 2002-10-10 A01 BBB 2001-08-08 A02 222 2002-07-08 A02 111 2000-01-01 A03 ....I want to get " where is the keep place for all balance by now?
AnswerUse a sub-select to get the last date - and make that match the original...
|Specific to MySQL|
|Sadly MySQL does not support nested SELECT statements nor does it allow views and so I don't see how this can be accomplished without copying the last date to another tables.|