Nested Join Or Some Other Operation?

  • Hello Friends,

    I have a database table that tracks the history of  Database operations on a a table. I have faced with a really serious situation.

    lOrderNo OrderDate   DeliveryDate   UserName  modifiedDate    Action                        

    ------------------------------------------------------------------------- --------------------------------------

    5354     2005-06-15  2005-06-17     bwb       2006-08-10      BEFORE UPDATE

    5354     2005-06-15  2005-06-19     bwb       2006-08-10      AFTER UPDATE

    5013     2005-06-15  2005-06-20     bwb       2006-08-10      BEFORE UPDATE

    5013     2005-05-15  2005-06-20     bwb       2006-08-10      AFTER UPDATE

    How can I find DISTINCT history_lSiparisNo on this table? I mean I would like to show all rows in a single column:

     

  • Could you repost the picture/description? My browser displays a red cross instead.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply