Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Posts
    63

    Unanswered: Querying data into excel + combining tables

    I have read-only access to a Oracle database and im able to query the data into excel from a table.

    data is seperated into three tables that have a relationship.

    Each record has a ID assigned to it and that ID appears on all three tables and each table displays differenct information related to the ID numbers.

    As an example, say I want to view all of the ID's since July 01 this year. I can collect the data out of the table where the data is greater than july 01.

    Now I have all the information obtainable by the first table, I need to query the 2nd table based on the IDs from the first table's results to get the additional information.

    The first way I was thinking of doing this in excel was a small loop which said "for each ID, query all the information in table2 where the ID (table2) = ID(table1)"

    The problem with this method is that it is very slow to query every time like this. Is there a faster method I can use?

    Or is there any commands I can use to collect the additional value based on the ID's based on their relationship.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Select
    from table2
    where create_date in (select * from table1 where order_date > '20130701')
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2012
    Posts
    63
    it appears that I can do this fine in Oracle however it doesnt work in excel (trying to put the data into excel)

    do you know why this might be?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >it appears that I can do this fine in Oracle however it doesnt work in excel
    Why don't you post this in Excel forum, since the problem is not with Oracle but Excel
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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