Date Query

[VirginiaR]

I have a database that I use to inventory items for a small store. Each item
has a posting date. I want to perform a query that has the earliest posting
date for the items. Help is greatly appreciated.

 

[Lou]

I have a database that I use to inventory items for a small store.  Each item
has a posting date.  I want to perform a query that has the earliest posting
date for the items.  Help is greatly appreciated.

As a first cut, I'd try this:

SELECT A.*
from Items as A
where A.PostingDate = ( SELECT MIN( PostingDate ) from Items where
ItemID = A.ItemID )