Sql max query

Hi

I normally use MySQL but have a query issue with SQL and wondered if anyone knows how to work it.

I have a table called ODBC_ORDER_ALL and I need to generate a report of the account number and last order date.

This table contains all orders for about 10 years by account number so I just need the unique account number and the last order date to come out.

Table: ODBC_ORDER_ALL

Field 1: ORDER_ACCOUNT_ID
Field 2: ORDER_DATE

Thanks in advance for you help.

Roy

are you trying to simply display the data from your table?

Check the manual for the GROUP BY statement.