Displaying last order date for each product in a table

[#1]

Hi,

I am new to QV and have encountered a problem which I'am sure has an easy solution.

I would like to display a table with 2 columns, one showing the part number the the other one showing the date it was last ordered.

I use these fields:

Load

partno

order_date

SQL SELECT*

From....

Anyone know a solution to this?

[#2]

Hi

Table2:

Load

partno

Max(order_date) as order_date

resident table1 group by partno;

drop table table1;

Regards

Ashish kumar

[#3]

Thanks for the answer. I tried it but there is still something wrong somewhere.

It says something is wrong with the syntax. That it cant find FROM. But I use RESIDENT so I cant understand why..