Post reply

1 MORE QUERY ?

  • April 21, 2005 at 11:08 am

    #185729

    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

    #554166

    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

    #554178

    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