Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: displaying results of 2 queries side by side - 10g

    Hi

    I have 2 queries which have the same PK columns but return a different number of columns.
    Query 1 returns 5 cols (1 row)
    Query 2 returns 2 coumns (1 row)

    Both queries have the datetime column result in common.

    Can I show the 6 cols from both queries side by side ?

    I've tried:

    select a.*, b.* from (query1) a join (query2) b on a.datetime=b.datetime

    but the datetime column (from the second query) is being repeated.

    How can I get rid of this column?

    Regards
    Shajju
    Last edited by shajju; 02-03-14 at 04:14.

  2. #2
    Join Date
    Aug 2008
    Posts
    464

    Resolved...

    Problem solved. Apologies for needless question.

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    How did you solved your issue?

Posting Permissions

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