Select data from a joined table with the newest date

To effectively retrieve the latest location and date for each seamark, consider using a LEFT JOIN combined with GROUP BY to organize data and aggregate results.

By eliminating direct location storage in the seamarks table, the database design streamlines updates. The changes table captures moves better without data redundancy.

Read at SitePoint Forums | Web Development & Design Community