Terra

MySQL isn't my strong point and today I was struggling to create a report with the earliest entry for a multiple occurring record until I found this: how-to-select-the-firstleastmax-row-per-group-in-sql/

That article cut right through the knot in my head. Perfect if you have multiple entries for a record & need to find the highest / lowest etc. Even gives you a solution if you need the find the highest / lowest N rows in a table.

Another nice visual helper is here: Coding Horror: A Visual Explanation of SQL Joins

Edith

__________________
Underground, Overground, Wombling Free!