Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    38

    Unanswered: Have u remember this Simple Special command?

    Hi...

    I beleive there is one simple but special command which is used to hide the repetitive columns of first table and show only the second table columns as like below..

    SELECT tab1.col1, tab1.col2, tab2.col1, tab2.col2
    from tab1, tab2
    where tab1.col1 = tab2.col3
    ...;

    Results:

    Tab1col1 tab1col2 tab2col1 tab2col2
    ========================
    1 a hi nice
    fyi this
    2 b hi nice

    In the above "fyi, this" are related to "1-a" (which are hide)..

    Anyone remember the command?????

    thanks & regards,
    avr

  2. #2
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    are you looking for something like in

    http://www.dbforums.com/t986378.html
    Oracle can do wonders !

  3. #3
    Join Date
    Jul 2003
    Posts
    38
    Originally posted by cmasharma
    are you looking for something like in

    http://www.dbforums.com/t986378.html
    Exactly....Thankyou very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •