(Not syntactically correct, but shows the point)
First step would be to do the following:
select item_no, max(created_date) as 'created_date' from itemposts group by item_no
Now you have, for every item_no, the date for which you want the itempost record.
Once you have that, you can build a query around the first query (Using the first query as a subquery) to get what you want, more or less like this:
Select
Item.item_no,
itemposts.posting_id,
from
item
join itemposts on (item.item_no = itemposts.item_no)
join (
select
item_no,
max(created_date) as 'created_date'
from
itemposts
group by
item_no
) sq on
(sq.item_no = itemposts.item_no) and
(itemposts.created_date = sq.created_date)
Submit an article or tip