1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Alternative to outer join

Discussion in 'SQL PL/SQL' started by hiswapna, Sep 17, 2009.

  1. hiswapna

    hiswapna Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    xxxxxxxxxxxxxxxxxxxxxx
     
  2. alternative for the query, select b.title,max(bg.returndate-bc.checkoutdate)"Most Date Out" from book1 bc,book2 bc where bc.title(+) = b.title group by b.title