Re: select latest records by date and location

[Active RFID]

Thanks Rick

Unfortunately it seems that sub queries can only work with an outer select that uses only one table (as 1 outer variable) whereas to construct my original 'single' table I select from 3 other tables (and I wanted to include any MAX sub query in that somewhere).

i.e. Select from 3 tables to get one table (as one or more variables), then find the MAX date for each unique name and location.

It may be possible with multiple sub-queries but this is beyond me.

Regards
Active