how
> in
> > the world can you
> > specify you want the max date record of
> > many unit_id records in the units table when
> there
> > is no identifying
> > mark in said table to say which one matches with
> the
> > max date.. or am I
> > missin
I have a table containing the fields unit_id,
temperature and date. This has data for around 20
units, with many 1,000's of records for each.
Further information on each unit is in another table
with just 1 entry per unit.
I need to select the most recent record for each unit
together with its ass
