April 21, 2005 at 11:08 am
I need this to get the Max for each number, so I want 3 results not the curent 1 result.
(SELECT MAX(ITEM_VEND_ID)
FROM ITEM_VEND iv,
ITEM i
WHERE iv.ITEM_ID = i.ITEM_ID AND
i.ITEM_NO IN ( '3501','3502','5052'))
THANKS AGAIN!!
April 21, 2005 at 11:39 am
SELECT i.ITEM_NO, MAX(ITEM_VEND_ID)
FROM ITEM_VEND iv,
ITEM i
WHERE iv.ITEM_ID = i.ITEM_ID AND
i.ITEM_NO IN ( '3501','3502','5052')
group by i.ITEM_NO
if this is not what you want, can you post some sample data and the table definition so we can give out the best possible answer?
April 21, 2005 at 12:04 pm
It worked, that was way to easy!!
Sometime one can not see the forest from the trees.
THANKS AGAIN.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply