I have a SQL question..didnt know wher else to ask. I have two tables: 1) customer table & 2) transactions. They both have an account column and account is a primary key in the customer table of course.

I want the SQL instructions to get the names of the customers' latest transaction (decided by date column) for each customer.

thanx in advance
Boomba