Eliminating redundant records in query results

[DrDuck]

I have made a query that takes info from a client table, and lists all of the visits for the past two years. The visit details are stored in a separate table which includes all the visit info for all customers. What I need is to only include the most recent visit for each client. If someone could show an example of an SQL statement that would not return the previous visits for each customer I'd like to try to adapt it myself. I'd appreciate any suggestions that might lead me to a moment of epiphany here.



Just make up your own fields for the example, I'm just looking for a path to explore to try and figure out the solution.

Thanks in advance for any advice.

[June7]

Google: SQL top record each group

Here's one
http://www.xaprb.com/blog/2006/12/07...-group-in-sql/

[DrDuck]

"Selecting the one maximum row from each group" explained it perfectly... thanks for the pointer June!! Much appreciated.