Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Table2:
Load
partno
Max(order_date) as order_date
resident table1 group by partno;
drop table table1;
Regards
Ashish kumar
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..