Skip to Content
0
Jul 14, 2020 at 11:11 AM

Querie for last sale date

281 Views

Hi,

I am looking for a querie to view all my items with the date the item was last sold.

This querie is not working:

SELECT T0.[ItemCode], T0.[ItemName], T0.[LstSalDate] FROM OITM T0

The column LstSalDate is empty.

How can I do this?

Thanks.